When I use the Requery method within a form, how can I keep the focus on the control which had the focus just prior to the requery? The solution needs to work with sub-forms too (i.e. requery a main form from within a subform and keep focus within the subform). Any help much appreciated.
I forgot to mention that my subform is a continuous form, so your method wouldn't work. For example, if field 2 of record 2 on row 2 had the focus, and I did a requery of the main form, how do I return focus back to field 2 of record 2 on row 2? Is there someway I can assign the control that has the focus to a variable, do the requery, then refer to the variable to setfocus?
try to avoid REQUERY, I'm not sure what you are trying to do, but REFRESH, REPAINT and MOVE to next record and back can do (maybe) your job.
REQUERY really re-reads whole recordset and although you can use GoToRecord, if you have multi-user database, you don't need to hit the same record and it's better (sometimes) to remember UniqueID, then REQUERY and then SEEK for that UniqueID..... but if you have few users, it's much easier to use denofdeath's method, it will work.