Stop Subform returning to 1st Record

[IainG]

Can anyone help me here please.

I am using a Subform (summary List) to allow users to scroll and select a record ID. The record ID has a OnClick event that moves the Main Form to the selected record. All working fine appart from the Subform refreshing once the Main form displays the record thats asked for!

I want the Subform to remain on the selected record and not refresh back to the first record.

Logic tells me that the Main form is refreshing after going to the record ID asked for and is forcing the Subform to refresh too.

Any idea if I can avoid this from happening?

 

[Pat Hartman]

Since the subform is controlling the mainform, the master/child links should be empty and that means that Access won't attempt to synchronize the records. Your code is causing the requery. Please post it.