Filtering a combobox

[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

 

[tina]

take a look at

http://www.mvps.org/access/forms/frm0028.htm

btw, this is a great site to bookmark.

hth