Duplicate Values in combo box

[mmcginley]

hi again,

I'm building a search function into my database and everything's fine apart from the fact that i have duplicate values in my combo boxes.

For example in the combo box 'market' i have many fields named Europe.

How do i replace these repeated values with one distinct value?

Cheers

 

[neileg]

Change the unique values property in the query to Yes.

Or, open the query in SQL view and change SELECT to SELECT DISTINCT