Hi All,

I am using an Access 97 database and ADO for modifying records. I have a multiple inner join query. When I add a record to the recordset of the this query, I add only some of the fields of the recordset and requery the recordset to show the related fields of record by Requery method.

Now here is the problem. I want to view the record that is just added but because the Requery method, bookmarking of the record isn't working. I can't use Find method because my criteria needs two columns for location and I don't want to use Seek method because by curserlocation is on the client side not server side.

What can I do for this problem?

Thanks for all replies