Variable interferring with SQL 1

[markvan]

I am attempting to update the notes field of my Orders table with a new note.
The newnote variable has the existing notes and the new note appended at the bottom and can be a few pages long.

When I attempt to run the SQL

SQL = "UPDATE Orders " & "SET Orders.notes = " & newnote & "WHERE Orders.OrderID = " & recordID

I get a Runtime error 3075 saying syntax error missing operator in query expression: And then the contents of the newnote variable displayed.

How do I encapsulate the content of my newnote variable so that it is updated into the field and not interpretted as part of the SQL command.

Mark Van Laarhoven
Dot Imaging Online Printers, Sydney, Australia.

http://www.dotimaging.com.au

 

[SkipVought]

Hi

This should really be posted in VBA Visual Basic for Applications (Microsoft) forum707

SQL = "UPDATE Orders SET Orders.notes = '" & newnote & "' WHERE Orders.OrderID = " & recordID

TICS around String Values. I assume the OrderID is NUMERIC. Otherwise that variable need TICS as well.

Skip,
[sub]
[red][/red]
[/sub]

 

[markvan]

Thanks Skip

Works perfectly now !

Mark Van Laarhoven
Dot Imaging Online Printers, Sydney, Australia.

http://www.dotimaging.com.au

 

[SkipVought]

I'm Sorry regarding the remark about where this should have been posted.

This forum is the correct one.

And thanks for the recognition.

Skip,
[sub]
[red][/red]
[/sub]