Daft Combo Box question?

[battenberg]

Hi

I want to populate a combo box based on a query, based on a table.

The table has several hundred rows.

The column I am interested in, although having several hundred lines to it, essentially has only 4 products listed.

How do I set my combo box to return just a list of the 4 products and not a list of hundreds of duplicate entries?

I would split the table, but this is not really an option at this stage due to the format of the raw source data before it is imported into this table

any ideas....??

Thanks in advance

 

[gemma-the-husky]

set the query properties to "unique values"

 

[Dreamweaver]

Unique Values Or Records In Query Propertys you'll have to play till you get it working but does depend on the fields you have in the query.

 

[battenberg]

Thank you... will give it a try!