Error 3075

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

running the following code from a command button in Access 2003, we have
Error 3075 Syntax error(missing operator in query expression)

DoCmd.RunSQL "UPDATE Travel SET Travel.TravelInsCertNo = 'Tour Operator's' "
& _
"WHERE
Travel.BookingRef=[Forms]![Travel]![BookingRef]"


What's wrong with the syntax & how can it be overcome

TIA for all advice

Tom
 
Try:

DoCmd.RunSQL & _
"UPDATE Travel SET Travel.TravelInsCertNo = ""Tour Operator's"" " & _
" WHERE Travel.BookingRef=[Forms]![Travel]![BookingRef]"
 
Thanks Van

That's fixed it

Cheers
Tom
Van T. Dinh said:
Try:

DoCmd.RunSQL & _
"UPDATE Travel SET Travel.TravelInsCertNo = ""Tour Operator's"" " & _
" WHERE Travel.BookingRef=[Forms]![Travel]![BookingRef]"

--
HTH
Van T. Dinh
MVP (Access)


Tom said:
running the following code from a command button in Access 2003, we have
Error 3075 Syntax error(missing operator in query expression)

DoCmd.RunSQL "UPDATE Travel SET Travel.TravelInsCertNo = 'Tour
Operator's' "
& _
"WHERE
Travel.BookingRef=[Forms]![Travel]![BookingRef]"


What's wrong with the syntax & how can it be overcome

TIA for all advice

Tom
Click to expand...
Click to expand...
 
Back
Top