Codes for Checking Rooms Availability

[oyk]

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.OpenRecordSe t ("qryRoomsAvail able",dbOpenDyn aSet)

However, this does not work. When I change "qryRoomsAvaila ble" to "tblRooms"
the codes seem to run alright.

Can anyone help me? TQ.

[Larry Linson]

Re: Codes for Checking Rooms Availability



"oyk" <okt128@streamy x.com> wrote in message
news:4441c161$1 _2@news.tm.net. my...[color=blue]
>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.OpenRecordSe t ("qryRoomsAvail able",dbOpenDyn aSet)
>
> However, this does not work. When I change "qryRoomsAvaila ble" to
> "tblRooms" the codes seem to run alright.
>
> Can anyone help me?[/color]

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
"qryRoomsAvaila ble" 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.