Duplicate data in my combo box

[Guest]

I posted earlier, and I left some details out.
I am using the wizard to look up values on a form. I want to click on a name
from a drop down list, and the form to find all of the records related to
that person.

I am seeing all of the names in the box multiple times.

Is there a way to get rid of duplicate data in the combo box?

 

[Ron2005]

The above will only work if you do NOT also have say ID or an
autonumber field as part of the returned data for the combo box. If
you do have it but do not need it, then take the ID field out but
change your bound column and number of columns and the column widths to
match the new format of the query results.

 

[Ron2005]

Add the word DISTINCT between the word SELECT and the first field name.

 

[John Vinson]

I posted earlier, and I left some details out.
I am using the wizard to look up values on a form. I want to click on a name
from a drop down list, and the form to find all of the records related to
that person.

I am seeing all of the names in the box multiple times.

Is there a way to get rid of duplicate data in the combo box?

Sounds like either the RowSource of your combo box is incorrect
(perhaps you could open it in SQL view and post it here), or - more
alarmingly - you have duplicate names in your table.

Open the form in design view; view the combo's Properties; select the
Data tab, and click the ... icon by the Row Source property. If it's a
SQL query post it here. If it's not... it probably should be <g>...

John W. Vinson[MVP]