Hi, guys - Rather simple but baffling question I have here...

I have a booking form for an accomodation database. I want the user to be able
to select the bed number they wish to book a customer into, bearing in mind,
rooms can contain any number of beds between 1 and 8.

For example,
John Smith wishes to book into Room 119, this room has 4 beds in it, the
user wishes to book him into bed No.2
Gary Smith wishes to book into Room 119 also, but this time into Bed No.3

I know I need a combo box for this but how can I deal with the RowSource?
i.e sometimes it will display a list of numbers 1 - 3 and other times it will
display a list of numbers 1 - 8, depending on how many beds are in the
selected room.
Any ideas how I can achieve this? Many thanks!

Ash.