There are three combo boxes on a continuous form -- Ballrooms, Tables, and seats.
Person Ballrooms Tables Seats
Eric Ballroom A Table1 Seat1
Andy Ballroom B Table2 Seat2
The Tables combo box needs to list all tables according to the ballroom. I can't preset the rowsource. If I do, the form will have the rowsource as "SELECT tables FROM tblTABLE WHERE ballroom = 'BallroomA'", which makes Table2 disapper because Table2 is no longer a valid table accoring to the rowsource.
I am thinking to preset the rowsource as "SELECT tables FROM tblTABLE" and change it to be based on the ballroom when user clicks on the "down arrow" button. Any work around? Any comments and suggestions is welcome.
Is what you are wanting, and to get that you want the user first to Input name... Select a Ballroom... after that is selected you want the list of tables to come up available for that ballroom. Right so far? Then you want the user to select an available table, and from there you want the seating to be in another list box (combo box whichever way you prefer)?
I can give you some code I used on list boxes. I actually used my for a search but you are wanting the same basic functionality (I think).