multiple drop down menus

[wort0987654321]

i am completing a database for a snooker club so thet they can book tables for members who want to booki a table. the club has three seperate snooker rooms, each of the rooms has a specific amount of tables in it. room one has 6 tables, room two has 4 and room three has 5 tables in it. i would like to have a combo box on my form that will allow a user to select a certain room. example. a p[erson want to book a table in room 1, click on the combo box in the form and select room one. the second combo box lets you chose which table that you would like to book. i would like this to only include tables up to number 6 as these are the only ones in this room. same for room two, i would only like tables 7 up to 10. and for room three i would like table 11 to 15.

i would only like it to work using two combo boxes

 

[ColinEssex]

Do a search for "cascading comboBoxes", this comes up regularly -and Hayley has posted a sample database of how to do what you're after.

Col

 

[ColinEssex]

Try this thread

http://www.access-programmers.co.uk...threadid=32882&highlight=cascading+comboBoxes

there's a sample here by DBL - thanks Dawn

Col