How to requery a form on activate without move from current record

M

Marco

Hello. How can I requery a form on activate it without move from current
record.

Imagine that I'm on form A, I want to click on a button to go on form B,
make some record set updates and then return to form B and see those changes
amde.

Is it possible?

Regards,
marco
 
A

Allen Browne

As you found, a Requery will cause you to move back to the first record.

So, save the primary key value first. Then requery, FindFirst in the
RecordsetClone of the form, and set the Bookmark.
 
Top