Update Query problem

[Reaper]

Why doesn't this line of code work?

DoCmd.RunSQL ("UPDATE tbltransactions SET tbltransactions.ynTicketConsumed = true WHERE tbltransactions.strticket = varTicketValue")

It opens an Inputbox asking for the value of "varTicketValue".

"varTicketValue" is declared Public as Variant and then is set just prior to running the SQL. I have verified that the variable is being properly set displaying it in a text box. If I input the proper value the Update query works correctly.

[hertfordkc]

Maybe you need brackets around varTicketValue to mark it as a control???
[varTicketValue]

[GrandMasterSexay]

did you bebug and check ?

[orange]

DoCmd.RunSQL ("UPDATE tbltransactions SET ynTicketConsumed = true WHERE strticket ='" & varTicketValue & "'")

This is assuming that strticket is text datatype (so quotes around the value are required)

[Reaper]

Unfortunately it's an autonumber. Still trying to weed out the bad naming that the previous programmer left me. So drop the quotes?

[GrandMasterSexay]

DoCmd.RunSQL ("UPDATE tbltransactions SET tbltransactions.ynTicketConsumed = true WHERE tbltransactions.strticket = "& varTicketValue &"")

[orange]

Unfortunately it's an autonumber. Still trying to weed out the bad naming that the previous programmer left me. So drop the quotes?

If strticket is number datatype, then just drop the quotes

DoCmd.RunSQL ("UPDATE tbltransactions SET ynTicketConsumed = true WHERE strticket =" & varTicketValue )

[Reaper]

Works great. Thanks.