Filtering a Combo Box

[Gary Hull]

I am creating a form to run in front of a table from another
MDB program.

The problem is with a combo box I use to select a record. The
table works like a flat based db. So the combo box shows
duplicate entries. I need to be able to filter the combo box
to show only one instance of a listing.

The combo box may show (B2D0D0D) 30 times I need to see it
only once

 

[Rick Brandt]

I am creating a form to run in front of a table from another
MDB program.

The problem is with a combo box I use to select a record. The
table works like a flat based db. So the combo box shows
duplicate entries. I need to be able to filter the combo box
to show only one instance of a listing.

The combo box may show (B2D0D0D) 30 times I need to see it
only once

The query you are using for the ComboBox has a property named "Unique Values".
Set that to Yes.

 

[Gary Hull]

Thanks for the quick answer!

I seem to be lost I find no "Unique
Values” property with the combo box or the query
I am using access 2000 and 2003

 

[Rick Brandt]

Thanks for the quick answer!

I seem to be lost I find no "Unique
Values” property with the combo box or the query
I am using access 2000 and 2003

ComboBox
RowSource

Press build button [...] to view RowSource query.

In Query designer open the property sheet. It will be the fourth property
listed.