Combo Box Selections

[Beeyen]

Good Day,

I have a sub form (in a tab of the main form) which has columns with six
rows, each with a combo box. I copied the rows from the first to create the
others. When I select through the drop down, an entry for any one combo box
the other rows with combo boxes fill with the same entry as what was
selected. The table has all the information (names) needed for the combo
boxes but each field should be able to show different names. What I would
like to be able to do is select with the drop down different names for each
row without it populating all others.

Row Source Type = Table/Query
Row Source = SELECT DISTINCTROW tblBenefitsEmployee.EmployeeID,
tblBenefitsEmployee.LastName & ", " & [FirstName] AS Expr1 FROM
tblBenefitsEmployee ORDER BY tblBenefitsEmployee.LastName & ", " &
[FirstName], tblBenefitsEmployee.FirstName WITH OWNERACCESS OPTION;;

Thanks for any assistance you can provide

 

[Chegu Tom]

You probably have the same ControlSource for each combo box

You must either have each box pointing to a different place or have no
ControlSource for them and use them some other way