Why no update? Help!

[Brian]

My update isn't updating the table. Why?

Code is:

strSQL = "Update AVAILABILITY " & _
"Set AVAILABILITY.[Booking ID] = " & varNewID & _
" WHERE AVAILABILITY.BookingDate= " & _
Forms![SINGLE BOOKING AVAILABILITY]!BookingDate &
_
" And AVAILABILITY.Period=" & Forms![SINGLE
BOOKING AVAILABILITY]!Combo8 & _
" And AVAILABILITY.Room=""" & Forms![SINGLE
BOOKING AVAILABILITY]!Combo10 & """"
DoCmd.RunSQL strSQL
MsgBox strSQL

where varNewID is declared as Long.
The MsgBox produces:

UPDATE AVAILABILITY SET AVAILABILITY.[Booking ID] = 86
WHERE AVAILABILITY.BookingDate = 07/09/2004 And
AVAILABILITY.Period = 1 And AVAILABILITY.Room = "H4"

Booking Table contains the record:

Booking Date = 07/09/2004 (date/time field)
Period = 1 (Number field)
Room = H4 (text field)
Day Number = 4 (Number field)
Booking ID = 1 (Number field)

I get an ACCESS popup box stating: You are about to
update 0 rows, etc. asking for a YES or No response

Why isn't the row in the table getting updated? Is it
something to do with the format of the date?

Also how can I stop the ACCESS popup box asking the user
to confirm update? I just want the update to take place
in the background.

Thanks for your help.

 

[Marin Kostov]

Enclose the data in pound signs!
Something like:
WHERE AVAILABILITY.BookingDate = #07/09/2004#

 

[Brian]

I tried wrapping the date in hash marks so it now looks
like #07/09/2004# but it still doesn't update the row.

Thanks