Using Combo Box to Populate a Form in Access

G

Guest

I am attempting to Populate a Form (Project Log Q Summary), based off a query
(Project Log Q Summary). The Query is based off a table (Project Log). I
would like to have the user select a combo box (cboAuditorName), choose the
correct ID, and have every record associated with that ID populate the form.
The Query can have many records with the same ID. The ID is based off a
table (Employee Table), which is connected to the Project Log table. Any
suggestions are appreciated.

Thanks,
 
M

Marshall Barton

JoeMammy said:
I am attempting to Populate a Form (Project Log Q Summary), based off a query
(Project Log Q Summary). The Query is based off a table (Project Log). I
would like to have the user select a combo box (cboAuditorName), choose the
correct ID, and have every record associated with that ID populate the form.
The Query can have many records with the same ID. The ID is based off a
table (Employee Table), which is connected to the Project Log table. Any
suggestions are appreciated.
Click to expand...


I think you can use the combo box's AfterUpdate event to set
the form's Filter property. The code would probably look
like:

Me.Filter = "ID=" & Me.cboAuditorName
Me.FilterOn = True
 

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 a text box with multiple records based on combo box selec 2
Code to populate combo box 1
rotating table records in a form 4
Populate a Combo Box 5
Populate query in a subform based on selection from combobox in main form 0
Capture an entry based on a selection 3
How do I add a COLUMN to combo box 4
Populate Datasheet Combo Box with Field List 1

Top