Filtering a combobox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry if this is a beginners question

in a form i have a combobox where i can pick a location and lets say the
options are "home" and "office"
I'd like a second combobox where i can select a room that depends on what
was chosen in the first combobox.

for example the location combobox has "home" & "office"
the room combobox has "boardroom", "my office", living room", "bedroom"

i want the room combobox to only display living room and bedroom if the
location combobox is set to home and to only show my office and boardroom if
the location combobox is set to office.

How can i do this?
Thanks
 
Back
Top