searching records by a "grandchild" of main form

[BradyL]

All,

My main table licenses, links to another table users, which links to another table institution (userID exists in licenses and users table, and instituionID exists in users and institution table). When veiwing the licenses form, I want to be able to search all the records by institution. I would be happy with either a combo box that is a record selector or a regular combo box that could be used in conjunction with a filter by form or search. While this is a potential one-many-many relationship, the case is rare, and displaying the first license with the selected institution would be fine.

I've been unsuccessful in serveral attemps. In particular I need help with the syntax of the row source and the control source.

Thanks in advance.

Regards,

Brady

 

[llkhoutx]

Use the contents of the combo box as the criteria in a query searching from the children presumably in a subform, you didn't say. Requery the bound subform or bound form on the combobox's AfterUpdate event. Your form or subform will then display all children. On your Form OnOpen event, set the combobox to null, and requery the form or subform displaying the children, otherwise, you see what was there last.