Add to recordset??

I have a recordset from some table. For example:

SELECT * FROM table WHERE field='x'

But, later I want to add another certain record of the same table to the recordset opened.

This is: If the original recordset has 10 records I want to add another 11 record.

Is this possible?

Thanks!

You could probably do it using a client batch cursor, and then never updating the DB if you don't want that 11th record inserted into the database......but you won't be able to save your changes later....unless you delete the 11th record before an update.....so i guess you can do it!

Hi
I know, this post is old, but i need exactly this feature. How can i do it?
thanks