Record on main form not changing after sorting subform

[russmann2000]

My main form (form view) and subform (datasheet view) are linked by ID. I can click on a record selector in the subform and the main form updates with the appropriate record. Since the subform is in datasheet view it has the ability to sort like a normal table (from the headers). When I sort the records and click on a record selector, it's like it loses the Master/Child linking and the main form will no longer update to the selected record. How would I retain the Master/Child link?

 

[arnelgp]

there must be a code/macro on the click event of your subform
because master/child is the opposite, the main form is the Independent form
while the subform is the dependent.

 

[arnelgp]

see this demo and sort the subform in any field.

 

[russmann2000]

Thanks so much for the help. I’ll check your suggestions and post the results later.