[Access 2000] Linking unbound subforms

[Merrion]

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?

[RobDog888]

When you say selection change do you mean record navigation change to a different record
or the highlight selection change?

[Merrion]

A navigation change in the "Clients" subform...

[RobDog888]

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