Search Button Based on Multiple Combo Boxes

M

missamay

I have a form containing multiple combo boxes that contain the names of
counties. The user can select from multiple counties using each combo
box to describe the project's multiple locations. Each combo box
(cmbCounty, cmbCounty1 etc) corresponds to a control source. I want to
create a search function or command button where the user can select a
county and the function would search all the cmbCounty boxes to find
the records that contain the value selected by the user, but I'm not
sure how to do this. I would like the user to be able to use a combo
box to the select the county for which they are looking and then have a
command button that would 'find the results' based on the selection.

If someone could help me to filter, query, or code the command button
to do this feat, I would appreciate it.

Thanks

Melissa
 

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

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Dynamic Naming of Form Button 3
Crating User Form to Add Names 1
synchronizing Combo boxes 1
Synchronizing State and County Combo Boxes 1
Link a text box based on drop down box with four options MS Word 365 0
Custom toolbar button for search and replace 1

Top