combo box question

[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

 

[Ken Snell [MVP]]

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

SELECT DISTINCT FieldName1, ....

 

[David]

Thank you Ken

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

SELECT DISTINCT FieldName1, ....