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

How do you enable a list based on a selected value?

P: 6

I would like to know if someone can help me with my issue. I have an input form and I would like to select data from a combo box based on an item in another combo box. For example, I have a combo box called “cboWO” that has a list of work order numbers. I would like the second combo box “cboEquipment” to enable when a user selects a particular work order number.

So, if a user selects work order number WO12345 from cboWO, the combo box cboEquipment will enable with a list of Equipment (A, B, C, D) associated with “WO12345”.

How can I accomplish this? I am not VBA smart and I am sure this will require some code.

I appreciate help from the experts. Thanks.
Aug 9 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 8,674
Have a look at:
Cascading Combo/List Boxes
Aug 9 '08 #2

Expert Mod 15k+
P: 31,662
Another helpful article : Example Filtering on a Form.

Let us know how you get on with these and Welcome to Bytes!
Aug 9 '08 #3

Post your reply

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