Jay Carax
asked on
Designing Outlook form
Hello,
I have two drop down menus, one called 'Floor' and the other called 'Area'. I want it so that when I select a type of floor, it will dynamically update the area drop down with relevant items. Can someone please show me how to link them?
An example would be
Floor
Values = Basement, Ground
If Floor = Basement
then values in Area should only display: Bike Store, Kitchen, Boiler Room
If Floor = Ground
then values in Area should only display: Reception, Lift Lobby, Library
Please see attachment for a basic visual.
Thanks
image001--1-.png
I have two drop down menus, one called 'Floor' and the other called 'Area'. I want it so that when I select a type of floor, it will dynamically update the area drop down with relevant items. Can someone please show me how to link them?
An example would be
Floor
Values = Basement, Ground
If Floor = Basement
then values in Area should only display: Bike Store, Kitchen, Boiler Room
If Floor = Ground
then values in Area should only display: Reception, Lift Lobby, Library
Please see attachment for a basic visual.
Thanks
image001--1-.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks - I will take a look at these now.
I just noticed a mistake. insert the line:
Case "Ground:
before:
#If Floor equals "Ground"
Case "Ground:
before:
#If Floor equals "Ground"
ASKER
Thanks!
http://www.slipstick.com/developer/designing-custom-forms/