Query based Combo box

  • Thread starter kellya via AccessMonster.com
  • Start date
K

kellya via AccessMonster.com

I have a reservation database that I am currently designing. I have a
reservation form with the arrival and checkout dates and the room id. I want
to make it so that when the user enters the dates the room-id (combo box)
field is populated with only available rooms based on this query

SELECT *
FROM tblRooms
WHERE Room_Num NOT in (select Room_Num from tblReservations where
RequestedStartDate <= EndBookingDate and RequestedEndDate >= StartBookingDate)
;

Question #1
Is this possible or do I have to use a subform?( I tried already and nothing
is happening)

Question #2
How do I get the combo box to show both the room type and the room id?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Room Availability Query 9
Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Combo boxes in excel 6
Reservation SQL Query 1
Combo box 0
Link a text box based on drop down box with four options MS Word 365 0
Requery Combo box in popup form 2

Top