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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remain on current record after requery 1
Requery of Accumulator Control on Form 1
Requery form 2
Return to same record after Requery 3
How to Requery a form without losing the current record 2
REQUERY SUBFORM 4
Requery 2
Requery a form from its subform, then add new 5

Top