View Full Version : combo box duplicates


Irie
08-09-2001, 05:47 AM
I have a combo box which contains duplicates of certain values.
How can I filter the combo box so that only one value is shown?

Thnx for any help or suggestions

KeaganQuilty
08-09-2001, 05:57 AM
The rowsource of your combobox should look something like this.

"SELECT field FROM table GROUP BY field"

This will eliminate your duplicates.

Keagan Quilty
Kilbride, Newfoundland