Syntax error

[BrianC]

I run the following query and get a syntax error:

Private Sub Command14_Click()

SELECT AVAILABILITY.BookingDate, AVAILABILITY.Period,
AVAILABILITY.Room, AVAILABILITY.[Booking ID]
FROM AVAILABILITY
WHERE (((AVAILABILITY.Date)=forms![SINGLE BOOKING
AVAILABILITY]![BookingDate]) AND ((AVAILABILITY.Period)
=forms![SINGLE BOOKING AVAILABILITY]![Combo8]) AND
((AVAILABILITY.Room)=forms![SINGLE BOOKING AVAILABILITY]!
[Combo10]));

End Sub

Can anybody see what the problem is? Thanks

 

[fredg]

I run the following query and get a syntax error:

Private Sub Command14_Click()

SELECT AVAILABILITY.BookingDate, AVAILABILITY.Period,
AVAILABILITY.Room, AVAILABILITY.[Booking ID]
FROM AVAILABILITY
WHERE (((AVAILABILITY.Date)=forms![SINGLE BOOKING
AVAILABILITY]![BookingDate]) AND ((AVAILABILITY.Period)
=forms![SINGLE BOOKING AVAILABILITY]![Combo8]) AND
((AVAILABILITY.Room)=forms![SINGLE BOOKING AVAILABILITY]!
[Combo10]));

End Sub

Can anybody see what the problem is? Thanks

Brian,
Please don't multi-post. If you feel you absolutely must post your
question to more than one news group, cross-post, by including each
other news group in the Newsgroups: line, separated by a semi colon.

That way, a reply posted in one group will be seen in all the others.
I answered this follow up post in the other group. I think it was in
Forms.