RunSQL asking for a parameter

[Brian]

I have a form with a button that executes some code which
amongst other things includes:

MsgBox varNewID
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

I get a popup box asking 'Enter a parameter value'
VarNewID. Why? The message before the strSQL shows that
varNewID contains a value such as 77.

What have I got wrong? Thanks.

 

[DebbieG]

At quick glance it looks like you're missing the " & before varNewID.

"Set AVAILABILITY.[Booking ID] = " & varNewID & _

HTH,
Debbie


I have a form with a button that executes some code which
amongst other things includes:

MsgBox varNewID
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

I get a popup box asking 'Enter a parameter value'
VarNewID. Why? The message before the strSQL shows that
varNewID contains a value such as 77.

What have I got wrong? Thanks.

 

[John Spencer (MVP)]

Answered elsewhere. You need to get the value of varNewID into the query
string. The SQL query does not recognize the VarNewID as a variable. So change
the second line of your query string as follows

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 & """"