E
Elwin
Use the OnCurrent() event of your SUBFORM to requery the
listbox on the subform. This event fires when you move
between records and will force the listbox to re-examine
the OrganizationID.
Me!ListBoxName.Requery
listbox on the subform. This event fires when you move
between records and will force the listbox to re-examine
the OrganizationID.
Me!ListBoxName.Requery
Link Query-----Original Message-----
Access 2002. I have a form linked to a subform by the fields
OrganizationID. The subform shows Contacts, and has a listbox, which is
used to select a particular contact for that form and forms below the
Contacts form.
listbox qryContactInfoOrganizations form OrganizationID qryOrganizations
Contacts subform OrganizationID qryContactInfo
Contacts