combo box question

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hi

I have a form with a combo box that shows data from a field in table1 and
inserts into table 2. My question is there are duplicates in table 1 so the
combo box shows duplicates. Is there a way to just show single entries.

Thanks,
David
 
Add the word DISTINCT between the SELECT word and the first field name in
the combo box's Row Source query.

SELECT DISTINCT FieldName1, ....
 
Thank you Ken



Ken Snell said:
Add the word DISTINCT between the SELECT word and the first field name in
the combo box's Row Source query.

SELECT DISTINCT FieldName1, ....
Click to expand...
 
Back
Top