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

K

kiri19

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:

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

Similar Threads

Populate subform with query results 0
Run Query on Subform Using VBA Macro Button 1
Access Main form/Subform Navigation 0
Update subform with combobox change on main form 1
Form query help 0
Parameter Value error in a Subform 0
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
Passing a value from subform or main form to subform query 4

Top