I have created a hotel booking system programme. However, I am puzzled as to how when the booking button is clicked it can search a database and find the best suited room (RoomType) and make sure that it is available (Date of Departure < system.date). It must also assign the value of the cost that is placed in the combobox as the room.roomprice value.

This data is held in two tables (Access):

Booking:
BookingID (Primary Key)
CustomerID (Foreign Key, Table:Customer)
Date of Arrival (Date)
Date of Departure (Date)
RoomID (Foreign Key,Table:Room)

Room:
RoomID (Primary Key)
RoomType (Text)
RoomPrice (Currency)
Floor (Number)

This has all got to be done within a single button click. Any ideas as to how I can place this into my vb code?

I have a rough query for picking a room that is best suited:
Code:
SELECT *
FROM Room.Booking
WHERE Room.[Room Type] LIKE "Room_TypeTextbox.text"
AND Room.RoomID = Booking.RoomID
And this for checking the availability:
Code:
SELECT *
FROM Booking
WHERE [Date of Departure] < GetDate()