problems with a combo box (1 Viewer)

[Walter]

Hi this must be really easy but I can't seem to figure it out. I have a combo box that gets its list from a table. Is there a way not to have duplicates of the same information in the combo box? Do i have to use VB to do it?

thanks for your time

 

[Darren]

No need for VB but a little bit of SQL.
Instead of just selecting the table of choice for ROWSOURCE in properties use SELECT DISTINCT as described below (extract taken from help).

DISTINCT
If two records contain Smith in the LastName field, the following SQL statement returns only one record that contains Smith:
SELECT DISTINCT LastName FROM Employees;

 

[Walter]

Thanks a lot it worked
you are the man!