Filter Duplicate Combo Entries

[Guest]

My combo box is based on a table that allows duplicate entries, is there a
way to filter the combo box so that it doesn't display the duplicate entries ?

Thanks

 

[Klein-4]

My combo box is based on a table that allows duplicate entries, is there a
way to filter the combo box so that it doesn't display the duplicate entries ?

Thanks

Yes. You can do this by creating a query based on the table and
setting the "Unique Values" property to "Yes". If your table was
named "tblTest" and the field to be used in the combo box was named
"TicketNo", then the SQL would be --

SELECT DISTINCT tblTest.TicketNo
FROM tblTest

Then you place this query in Row Source for the combo box.

Ross La Haye

 

[Guest]

Ross La Haye - This is the setup I am using except for the "Unique Values"
property is not set to "Yes" in my table because I need to allow duplicate
entries - I just don't want to see them in my Combo box.

Thanks

 

[hawkmoon269]

Ross La Haye - This is the setup I am using except for the "Unique Values"
property is not set to "Yes" in my table because I need to allow duplicate
entries - I just don't want to see them in my Combo box.

Thanks









- Show quoted text -

....that's why you create a query rather based on the table rather than
use the table...

Ross La Haye

 

[hawkmoon269]

...that's why you create a query rather based on the table rather than
use the table...

Ross La Haye- Hide quoted text -

- Show quoted text -

Sorry, just realized that was not grammatical...what I meant
was...that's why you create a query based on the table rather than use
the table... ;-)

Ross La Haye