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

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.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Marco" <Marco@discussions.microsoft.com> wrote in message
news:A49E7540-FA65-438D-865D-BC5B68049C2F@microsoft.com...
> 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