Filtering a Combo Box

  • Thread starter Thread starter Gary Hull
  • Start date Start date
G

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

The query you are using for the ComboBox has a property named "Unique Values".
Set that to Yes.
 
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
 
Gary said:
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
Click to expand...

ComboBox
RowSource

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

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