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!