Compile error: Expected end of statement

[ritati]

Hello,
I'm trying to put a single command


in several lines. The line of code is much wider than the
editing screen. I'm putting underscore _ to separate lines
of code. When I try this
my code turns red and VBA tells me I have an
error expected end of statement.
Can someone please explain how this is done.
code:
DoCmd.RunSQL "INSERT INTO tblInventoryTransactions ([TransactionType],[ProdID], [Quantity],[PurchaseOrderID] )VALUES (" & 1 & ", " & ProductId.Value & "," & Quantity.Value & " , " & PurchaseID.Value & ");"

[amrut]

The underscore must be immediately preceded by a space and immediately followed by a line terminator (carriage return/enter key).
Other option is
Dim strSQL as String
strSQL="your first line "
strSQL=strSQL & "your next line " 'note space at the end of line
strSQL=strSQL & "your next line "
DoCmd.RunSQL strSQL