I am wanting to prevent a double booking. I have a form called:
frm_Booking which records an ArrivalDate and DepartureDate

and another form

frm_Building_Booking which records a BuildingID number

I want to ensure that a customer cannot book a BuildingID for an ArrivalDate and DepartureDate it it has already been booked by another cusotmer or book any on the days between.

However a customer should be able to book a BuildingID on the DepartureDate.

:bambooz: