Form problem, going back to first record

[Miller84]

Hi,

After I run a requery command in an Afterupdate event (to update a second subform), the subform in my main form refreshes and returns me to the very first record in the main form. How do make sure that after the requery or refresh, the form keeps me on that record?

 

[KenHigg]

There could be several issues here - My first shot would be to try a refresh instead of a requery...

kh

 

[Rich]

Your using the wrong method, you need to reference the subform correctly
Forms!Form1.Form. etc Requery, use the code builder to obtain the correct syntax

 

[Miller84]

Where do I put that command then? Does that command save the record in subform AND update subform2 at the same time? Its essential that subform 2 is updated after an addition to subform 1 has been made.