Filter Duplicate Combo Entries

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

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
 
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
Click to expand...

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
 
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
 
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 -
Click to expand...

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

Ross La Haye
 
...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 -
Click to expand...

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
 
Back
Top