Firstly I am a new Access user - so please bear in mind when replying.
I have built a simple database which has 7 columns (including ID). I want to be able to search on these individually so I have set up a query for each one.
However, other than 1 column, I would like to be able to choose from a drop down menu to be able to select from a defined list and then search on that.
As such, I have followed instruction online and have created a blank form and on there created a ComboBox, which I have linked to the table to get inputs. Side problem, I can't get it to stop showing duplicates even when I click the 'unique inputs' tick box. In case it's relevant.
I then on the table have used [Forms]![Search]![Combo17] in Criteria under the relevant column to link it to Combobox.
On the Form I have then added a Command Button, which I have linked to Run Query. However the return query is always blank when it returns.
I have re-done all the links to make sure that I am referencing the correct locations. Plus checked the query work when using a text entry e.g [Enter Country] in the Criteria field. When you type it in it shows correctly.
What is going wrong that it doesn't link with the ComboBox?
][1]


