I Irie Registered User. Local time Today, 20:35 Joined Jul 12, 2001 Messages 27 Aug 9, 2001 #1 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
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
K KeaganQuilty Registered User. Local time Today, 17:05 Joined Jun 28, 2001 Messages 51 Aug 9, 2001 #2 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
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