Populating many combo boxes as result of combobox choice

[blip]

I’m not sure I’ve posted in the correct place however….

I’ve been trying to get this to work for some time now.

I have created 10 combo boxes on an Excel form. The first one contains a name, the others only yes and no.

When I choose a particular name I would like the other 9 boxes to automatically update yes or no corresponding to a sheet that contains all the values like a table would.

So far my code:

NameControl.Val ue = NameControl.Col umn(0)
BoxControl_01.V alue = NameControl.Col umn(1)
BoxControl_02.V alue = NameControl.Col umn(2)

[Scott Price]

An Excel form?

If this is truly a spreadsheet, it sounds like you're expecting database behavior from a spreadsheet (which it inherently doesn't support). However, if this is a tipo and you are really working with an Access form, the answer becomes quite easy. Simply bind the combo boxes to a query that pulls the data you wish to display based on the first selected choice.

Regards,
Scott