Hi
I am trying to link 2 combo boxes together to create a basic search.
The first combo box has 4 options, which are 4 column headings in the table.
Depending on what they choose in this combo box I need the second box to run a query and then show the results of the query that groups all the different names in the chosen column.
Am I going the right way about creating a search form?
In VBA how do I get the second combo box to list the results from the query?
Any help would be great.
I am trying to link 2 combo boxes together to create a basic search.
The first combo box has 4 options, which are 4 column headings in the table.
Depending on what they choose in this combo box I need the second box to run a query and then show the results of the query that groups all the different names in the chosen column.
Am I going the right way about creating a search form?
In VBA how do I get the second combo box to list the results from the query?
Any help would be great.