Hi, I wonder if anyone can help. I'm trying to open a recordset using the code below, but I think there's something wrong with the syntax of the last part of the WHERE clause. Everything works fine until I add the 'BookingDate = dtDateHolder' at the end, then it brings back no results. It works perfectly as a query, so I'm guessing either my syntax must be wrong, or there is a problem with the data type in the dtDateHolder field. Please help!
Public dtDateHolder As Date
Public intRoomIDHolder As Integer
intRoomIDHolder = Me.cmbRoomSelect ' insert value from combo box on form
dtDateHolder = Me.DateSelect ' insert value from date selector on form
Set rsRecordsToBook = CurrentDb.OpenRecordset("SELECT tbl_BookingsbyRoom.RoomName, tbl_BookingsbyRoom.BookingDate, tbl_BookingsbyRoom.BookedBy, tbl_BookingsbyRoom.Selected, tbl_BookingsbyRoom.Lock FROM tbl_BookingsbyRoom WHERE (tbl_BookingsbyRoom.Selected=True) AND (tbl_BookingsbyRoom.RoomName = " & [intRoomIDHolder] & ") AND (tbl_BookingsbyRoom.BookingDate = #" & [dtDateHolder] & "#);")