Requery

[Guest]

How do you requery without your form returning you to record 1? I believe I
have to use the Requery method through visual basic instead of the Requery
action (macro) that I am now using. I would like it to automatically requery
every specified amount of time, but keep the user on the same record/doing
same thing. When the current macro is run, it brings the user to record 1
after updating. My current code is the basic action:
DoCmd.Requery ""
Any suggestions??

 

[Luiz Cláudio C. V. Rocha [MVP]]

Hi,

you can store the PrimaryKey value in a variabble, and after requering the
form, you can go back to the record.

Luiz Cláudio C. V. Rocha
São Paulo - Brazil