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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicate values in Combo Box?

Status
Not open for further replies.

ronmon

IS-IT--Management
Feb 25, 2002
66
IE
I have a problem. I have a search form that allows the user to select certain criteria. The only problem is when the user wants to select a vlaue from the combo box it displays every value entered e.g in location it will display 200 "LETTERKENNY GENERAL" and then 65 "SlIGO" this is because this is how many times these values are present in the table. Is there a way to get rid of the duplicates or to create another table and linking it or something to the main table
 
If I'm not mistaken, it seems that you're capturing the lookup values via a query... Select the query to be Distinct Values... This will make the lookup specific...

Roy aka BanditLV
Las Vegas, NV
 
You are a genius Solved the problem perfectly Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top