Runtime ERROR 3134

[DS]

I'm using this SQL phrase that is working on Several forms, but n one
form I keep getting he dreaded 3134 Error. Any help appreciated.
Thanks
DS

Me.TxtTableID = Nz(DMax("[TableID]", "PCenter"), 0) + 1
Dim SectionSQL As String
DoCmd.SetWarnings False
SectionSQL = "INSERT INTO PCenter
(TableID,SectionID,TableName,TTypeID,Active)" & _
"Values(" & Forms!Easy12!TxtTableID & "," &
Forms!Easy12!TxtSectionID & " " & _
"'" & Forms!Easy12!TxtTableName & "'," & Forms!Easy12!TxtType & ","
& Forms!Easy12![ChkActive] & ")"
DoCmd.RunSQL (SectionSQL)
DoCmd.SetWarnings True
Me.ListTables.Requery

 

[Steve Schapel]

DS,

Looks like you are missing a comma between Forms!Easy12!TxtSectionID and
Forms!Easy12!TxtTableName.

 

[DS]

DS,

Looks like you are missing a comma between Forms!Easy12!TxtSectionID and
Forms!Easy12!TxtTableName.

Your're absolutly right! Sometimes you can't see the forrest for the
trees. Thats what I get for working so hard!!!
Thanks, Steve
DS