help with Requery

[Dazza666]

I'm having some difficulty getting access to do what I need,

I have an overview form that uses simple command buttons to open other forms. when these other forms are closed I need any status changes to be reflected in the overview form, I can do this by using a requery on the onClose event of the opened form.

This works fine but after the requery access always returns to the first record on the overview page, I need a way to stop this or to loop back to the record selected before the requery.

any help is appreciated

Thanks

 

[namliam]

Store your PK in a variable before doing the requery.

Then search for your PK after to "jump" back to the right record afterwards.

 

[Dazza666]

Store your PK in a variable before doing the requery.

Then search for your PK after to "jump" back to the right record afterwards.

Hey thanks for the reply, i'm trying to use docmd.findrecord to do as you suggested but I can't find a way to limit the search to the id number box? I have a couple of other number fields on the form that may be picked up instead of the ID, any thoughts?