Combo Box Selections

B

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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top