Populate query in a subform based on selection from combobox in main form


Joined
Aug 27, 2012
Messages
1
Reaction score
0
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"
 
Last edited:
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top