Using Combo Box to Populate a Form in Access

  • Thread starter Thread starter Guest
  • Start date Start date
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,
 
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
 
Back
Top