Runtime ERROR 3134

D

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
 
S

Steve Schapel

DS,

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

DS

Steve said:
DS,

Looks like you are missing a comma between Forms!Easy12!TxtSectionID and
Forms!Easy12!TxtTableName.
Click to expand...
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
 
Top