Eliminate Duplicate Record in Combo Box.

[alexkong2003]

Hi all,

This is an intersting question that my friend ask me... hope someone can help to solve it.

In a combo box i use to list out all the company in a table that with the duplicate of the company is allowed. Do someone have a good idea to filter the combo box when detect a duplicate data and just showing one of each company only? or can i create a query with just listing one of each company from the table with all those duplicate company data?

Thank you.

Regard,
alex

 

[dancarter]

In your query, right-click in the design area, choose properties and set unique records to Yes.
Make sure you only bring in the company name to the query though.
Hope this helps!

 

[alexkong2003]

YES! It work! Thanks you so much dancater....