ADO Recordset issue

Hi,

I want to merge two ADO recordsets with the same structure (from the same table). First I thought of adding new records and filling them with values of the other recordset. This is not good enough, because I have to keep the status (property), and if you add new records, it always gets adRecNew as value.

Is there a way to merge recordsets with the same structure and keeping the status ?

Thanks,
Joris.

you can use a union in your sql statement like this

Select Product, Description from TableA
Union
Select Product, Description from TableB