Record on main form not changing after sorting subform (1 Viewer)

russmann2000

Registered User.
Local time
Today, 14:39
Joined
Mar 25, 2018
Messages
13
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 03:39
Joined
May 7, 2009
Messages
19,169
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 03:39
Joined
May 7, 2009
Messages
19,169
see this demo and sort the subform in any field.
 

Attachments

  • masterchildOpposite.accdb
    512 KB · Views: 166

russmann2000

Registered User.
Local time
Today, 14:39
Joined
Mar 25, 2018
Messages
13
Thanks so much for the help. I’ll check your suggestions and post the results later.
 

Users who are viewing this thread

Top Bottom