Problems with INSERT INTO

[GabyFont]

Hi,

I'm having trouble with the INSERT INTO statement, I have this code

Dim SQL As String

SQL = "INSERT INTO trRecord(TicketID, lastModified, modelID) VALUES(" & Me.tickID & ", now(), " & Me.modID & " )"
DoCmd.RunSQL SQL

End Sub

when I try to use it with only one field, it works fine, but when I have more than one field(like here that I have 3), it gets me an error
Ideas???

Thank You
Using Access2007

[jaxjagfan]

Hi,

I'm having trouble with the INSERT INTO statement, I have this code

Dim SQL As String

SQL = "INSERT INTO trRecord(TicketID, lastModified, modelID) VALUES(" & Me.tickID & ", now(), " & Me.modID & " )"
DoCmd.RunSQL SQL

End Sub

when I try to use it with only one field, it works fine, but when I have more than one field(like here that I have 3), it gets me an error
Ideas???

Thank You
Using Access2007

Change the Dim SQL to Dim strSQL

strSQL = "INSERT INTO trRecord(TicketID, lastModified, modelID) VALUES(" & Me.tickID & ", " & now() & ", " & Me.modID & " );"
DoCmd.RunSQL strSQL