Using dates and room numbers in hotel database

please don't multipost. for more information, see
http://home.att.net/~california.db/tips.html#aTip10.

hth


"Mike" wrote in message
...
Hi
Im 1 month old to access.

I have a list of room numbers say 1-10 and type of bed in a table
called rooms

Then I have another table called check in which requires the checkin
date the ceck out date and the room number. How could I go about
having only available rooms between these dates show up in a drop down
list? A webpage or advice would be greatly appreciated.

I have been to create a dropdown list. Would a query be the way to
go?
Does what Im describing require VBA knowledge
Thanks
Mike