Combo Box Limitations

J

Jasun74

I have a comobo box which initiates a search via the double click action to
another form.
However when the user inputs data to start their search I would like to not
have the drop down list show multiples of records (of the same name) so as to
simplify their search and enable a "multiple choice" type of option.
 
L

Linq Adams via AccessMonster.com

If I understand your question correctly, in the rowsource for your combobox,
after SELECT add DISTINCT so that you have

SELECT DISTINCT yada, yada, yada.
 

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
Link a text box based on drop down box with four options MS Word 365 0
How to make repeating drop-down lists? 2
Creating a Search using a combo box and then creating a report. 4
Combo box 0
Dynamic Naming of Form Button 3
Paragraph numbering in Word 1
Combo Boxes that filter database 3

Top