Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo box duplicates

Status
Not open for further replies.

galesjam

Technical User
Sep 20, 2002
10
FI
Hello!!

There is probably an easy answer that I just can't see, but I'll ask anyway!

I have a table containing various data (customer name, ref number, parts, etc..). I have created a form that allows me to pick a customer from a combo box and then choose to either display a report for that customer or print the same data.

The problem is that the combo box shows the same customer again and again (as well as the others). Basically I want the combo box to only show each customer once (no duplicates).

Any ideas?
 
In the RowSource you will have a statement starting 'SELECT...

Change this to SELECT Distinct ...

Distinct suppresses duplicates.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top