"oyk" <ok****@streamyx.com> wrote in message
news:44**********@news.tm.net.my...
I have a form with, among others, controls for RoomNo., CheckInDate and
CheckOutDate. I would like to check whether the RoomNo selected is occupied
for the period as stated in CheckInDate and CheckOutDate.
I have used the OpenRecordSet method for the AfterUpdate event in the
form, as follows:
Set rs = db.OpenRecordSet ("qryRoomsAvailable",dbOpenDynaSet)
However, this does not work. When I change "qryRoomsAvailable" to
"tblRooms" the codes seem to run alright.
Can anyone help me?
No, not likely. Your description is very vague, you don't show the code, you
don't describe the details of the error you receive, and the instruction on
which you receive it, and you don't give us a clue as to what
"qryRoomsAvailable" may do.
Essentially, you have said, "There's something wrong somewhere; how do I fix
it?"
Ross Perot, when he was running for President, used to say, "The devil is in
the details." He was paraphrasing Mies Van Der Rohe, who said, "God is in
the details." I can't promise you an answer, but if one is to be found, we
do need the details.