Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Filtering Criteria for a Combo Box
- Thread starter Azie
- Start date
Set up a query with criterion for the Customer ID field to "like Forms![Form1]![Text1]" where Form1 is your form and Text1 is the control with the current customer's Id in it. (Your set up may differ - this is just to illustrate).
Then set the combo box's RowSourceType to Table/Query and the RowSource to the name of the query. Have fun!
)
Alex Middleton
Then set the combo box's RowSourceType to Table/Query and the RowSource to the name of the query. Have fun!
)Alex Middleton
- Status
Similar threads
