I have a main form "Invoices" that has a subform "Client" and a subform "Address" which are both unbound. How do I make a selection change in "Client" force the "Address" form to get the correct address?
Printable View
I have a main form "Invoices" that has a subform "Client" and a subform "Address" which are both unbound. How do I make a selection change in "Client" force the "Address" form to get the correct address?
When you say selection change do you mean record navigation change to a different record
or the highlight selection change?
A navigation change in the "Clients" subform...
Use the Form_Current event. It will fire whenever the navigation of the records change. In that
procedure you can sync up your forms.
HTH