By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,501 Members | 2,850 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,501 IT Pros & Developers. It's quick & easy.

Populating many combo boxes as result of combobox choice

P: 4
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.Value = NameControl.Column(0)
BoxControl_01.Value = NameControl.Column(1)
BoxControl_02.Value = NameControl.Column(2)
Feb 14 '08 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
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
Feb 14 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.