Remain on current record after requery

[siwilsonchan]

Hello,

I know almost nothing about programming, but I really need some help with what I am trying to do.

I've been trying to figure out how to do this for a couple of days now. I tried searching through this forum, but I just can't seem to be able to apply the methods discussed here to my work.

I am trying to add a command box in which I could requery my record. I was able to accomplish this by typing "me.requery" under build event. However, whenever I click on the command box, the record refreshes, but it goes back to the first record. How do I requery but stay on the current record?

Thanks for your time,

Wilson

 

[Abraham Andres Luna]

Can you add code to the button click event to remember the current record, and then after the requery it selects the current record?