Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Using Combo Box to Populate a Form in Access
0 views
Skip to first unread message
JoeMammy
Nov 12, 2007, 1:15:00 PM11/12/07
to
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.
(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,
--
Joe Mammy
Marshall Barton
Nov 12, 2007, 4:13:54 PM11/12/07
to
JoeMammy wrote:
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
--
Marsh
MVP [MS Access]
0 new messages