Using Combo Box to Populate a Form in Access

J

JoeMammy

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

Auto populate value from one task to another in MS PROJECT 0
Creating a Search using a combo box and then creating a report. 4
Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Task Information Dialog Box not making duration changes to task 0
Link a text box based on drop down box with four options MS Word 365 0
Display weeks from a Milestone 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top