How to get unique values in combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have created a combo box for users to search from, but I can't seem to
get rid of duplicates. I've looked in the properties section to set Unique
Values to Yes, but I can't find that property. Any help?

Thanks!
 
In the properties go to the rowsource and then use the group by function
 
Daniel

What is the SQL statement of your combobox's RowSource?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You must log in or register to reply here.

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

Unique values in a combo box 3
Using Unique Values and Unique Records 13
Combo Box 2
Unable to select a value from combo box 3
combo box fills in arbitrary value 7
I want to use combo boxes to locate specific records 4
Combo Box default value 1
Default value to unbound combo box 1

Back
Top