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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox 1
comboboxes 3
populate a combobox based on unique values in another workbook 16
Query in a sub form 1
Combobox not in same order as table 2
Query to populate combobox with names of tables, only if they contain data 2
<all> field in combobox 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top