Dependant lists using Combo Boxes
 

I want to create dependant dropdown lists using combo boxes from the Forms
toolbar.
I have created an exit survey form using check boxes and combo boxes from
the Forms toolbar. Now my boss wants me to add an occupation category where
the occupation is e.g. Information Technology, then within that occupation
they may be Help Desk Support or Mainframe Supervisor etc. Then there may be
another occupation category for Finance where they may be in contracting or
accounts payable etc.
I looked at Debras site and, unless Ive missed something, there is nothing
covering dependent lists using combo boxes from the Forms toolbar, maybe it
is not possible to do because Im sure she would have covered it. I want to
keep my survey uniform and I didnt really what to have a mix of boxes or to
have to go back and change everything to the Control Toolbox because I do
prefer to use the Forms Toolbox.

Dependant lists using Combo Boxes
 

hi
she did cover it. you just look on the wrong page.
http://www.contextures.com/xlDataVal10.html
works like this
load combo box 1 the normal way, setting the row source.
in the combo box 2
if combobox1.value = select1 then
combobox2.rowsource = range("A2:A10")
else
combobox2.rowsource = range("B2:B10")
end if
you will need a if then for each selection option in combobox1. if you have
a lot, you may concider a select case.

regards
FSt1

"Lynda" wrote:

I want to create dependant dropdown lists using combo boxes from the Forms
toolbar.
I have created an exit survey form using check boxes and combo boxes from
the Forms toolbar. Now my boss wants me to add an occupation category where
the occupation is e.g. Information Technology, then within that occupation
they may be Help Desk Support or Mainframe Supervisor etc. Then there may be
another occupation category for Finance where they may be in contracting or
accounts payable etc.
I looked at Debras site and, unless Ive missed something, there is nothing
covering dependent lists using combo boxes from the Forms toolbar, maybe it
is not possible to do because Im sure she would have covered it. I want to
keep my survey uniform and I didnt really what to have a mix of boxes or to
have to go back and change everything to the Control Toolbox because I do
prefer to use the Forms Toolbox.

Dependant lists using Combo Boxes
 

Thank you for your response FSt1, but i think you missed my meaning. I was
wanting to use the Combo Box from the FORMS toolbar NOT the Control Toolbox.
I did look at Debra's page and it all relates to the Control Toolbox. I don't
understand what you mean by a select case.

"FSt1" wrote:

hi
she did cover it. you just look on the wrong page.
http://www.contextures.com/xlDataVal10.html
works like this
load combo box 1 the normal way, setting the row source.
in the combo box 2
if combobox1.value = select1 then
combobox2.rowsource = range("A2:A10")
else
combobox2.rowsource = range("B2:B10")
end if
you will need a if then for each selection option in combobox1. if you have
a lot, you may concider a select case.

regards
FSt1

"Lynda" wrote:

I want to create dependant dropdown lists using combo boxes from the Forms
toolbar.
I have created an exit survey form using check boxes and combo boxes from
the Forms toolbar. Now my boss wants me to add an occupation category where
the occupation is e.g. Information Technology, then within that occupation
they may be Help Desk Support or Mainframe Supervisor etc. Then there may be
another occupation category for Finance where they may be in contracting or
accounts payable etc.
I looked at Debras site and, unless Ive missed something, there is nothing
covering dependent lists using combo boxes from the Forms toolbar, maybe it
is not possible to do because Im sure she would have covered it. I want to
keep my survey uniform and I didnt really what to have a mix of boxes or to
have to go back and change everything to the Control Toolbox because I do
prefer to use the Forms Toolbox.