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

Clear Combobox Selection not working 0
Query in a sub form 1
Need combo box to refresh when moving to new record 2017 1
Subform not performing requery properly 1
Combobox not in same order as table 2
Query to populate combobox with names of tables, only if they contain data 2
Missing something basic - Combobox updating table 2
Query Parameter using multiple options 0

Top