MS access 2010 Populate query in a subform based on selection from combobox in main form
I have a Main form "ClientInformation" and it's datasheet subform "VisitResultsQueryForm"
I would like to be able to select a cliend ID in a combo box(searchCombo) on the main form and the fields on the subform autopopulate based on the selection on the main form.
The subform is based on the visitResultsQuery query.
on change for the searchcombo i have : DoCmd.OpenQuery "visitResultsQuery"
in the visitResultsQuery criteria for the Client ID i have : [Forms]![ClientInformation]![searchcombo]
so far it works but opens up a datasheet instead of populating in the subform "VisitResultsQueryForm"
I have a Main form "ClientInformation" and it's datasheet subform "VisitResultsQueryForm"
I would like to be able to select a cliend ID in a combo box(searchCombo) on the main form and the fields on the subform autopopulate based on the selection on the main form.
The subform is based on the visitResultsQuery query.
on change for the searchcombo i have : DoCmd.OpenQuery "visitResultsQuery"
in the visitResultsQuery criteria for the Client ID i have : [Forms]![ClientInformation]![searchcombo]
so far it works but opens up a datasheet instead of populating in the subform "VisitResultsQueryForm"
Last edited: