Unique list for multiple comboboxes.

  • Thread starter Thread starter Juju
  • Start date Start date
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.
 
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.
 
Back
Top