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?



Thank you for your time,

Wilson

[isladogs]

That is how requery works
This is a very commonly asked question & if you do a site search you will see many responses & work-rounds.
For example, try looking at the links at the bottom of this page
Solutions include storing the current record number before requerying then returning to that record after requerying

If you are trying to 'refresh after a 'calculation' you can use Recalc instead - it stays on the same record
There are also Repaint & Refresh commands which do similar but not identical things

See http://www.projectperfect.com.au/blo...h-and-repaint/