Contonous forms + Requery

[yoni]

Hi! <br>

I have a client-server set of Access programs, using continuous forms. I have to update each program all the time and get the new records (so I must use ReQuery), but ReQuery makes the user lose the focus of the control and of the record. How can I keep the Requerying process transparent to the user? <br>

 

[elizabeth]

Would this help?<br>
<br>
strBookmark = Me.Bookmark ' set bookmark before leaving record<br>
' Do whatever<br>
Me.Bookmark = strBookmark ' return to bookmarked record