Unique list for multiple comboboxes.

J

Juju

Hi, i have a form with a combobox. This combobox displays a list of records
to be selected for a query. How can I make it to display only unique
records??

*using ACC2003
** I have tried setting 'Yes' the Unique property in a query , but did not
work.

thank you.
 
A

Allen Browne

Post the SQL of the query.

When you set Unique to Yes, it adds DISTINCT to the SQL statement. My guess
is that you have multiple columns here, and the combination of them all is
distinct, even though the bound column values are not distinct.
 
Top