Hi all,

New to Access, and probably going about this in a convoluted way, but here goes:

I have a Main Form with a List (List1) of Clients. I currently have it set up so that a subform is linked to List1 to show records associated with the Client selected in List1.

The subform has a header that shows the Client Name and has a button that opens up a form for data entry. The info in the header works - when I select a Client from List1, the name of the Client (in the subform header) matches the Client selected in List1. However, in the body of the subform I have another List (List11) that should show the records associated with the selected Clients in List1, but does not update until I hit a button on the subform that refreshes the subform. Ideally, List11 should update automatically after an update to the selection in List1, but I cannot for the life of me figure out how to use VBA/Macros/etc to refresh a subform on an action in the main form. Can anybody help?

​

Edit: Solved by u/AccessHelper