Form vb syntax error on INSERT INTO

[Guest]

From a form procedure I'm trying to write the value into a table. I have
tried keeping it simple at first, i.e. just writing a static number to prove
it works prior to adding the field name, however I am getting a syntax error.

Set DB = CurrentDb
strSQL = "INSERT INTO Criteria (GetValueN)VALUES " & "2" & ";"
DoCmd.RunSQL (strSQL)

My table is [Criteria]
The field is [GetValueN] and it's numeric
The field name is [COMPETENCY_ID] and the Control Source is [Competency
Identifier]

Help please?

 

[Douglas J. Steele]

strSQL = "INSERT INTO Criteria (GetValueN) VALUES (" & "2" & ")"

or, to use the control,


strSQL = "INSERT INTO Criteria (GetValueN) VALUES (" & Me.Competency_ID &
")"

 

[Rick Brandt]

From a form procedure I'm trying to write the value into a table. I
have tried keeping it simple at first, i.e. just writing a static
number to prove it works prior to adding the field name, however I am
getting a syntax error.

Set DB = CurrentDb
strSQL = "INSERT INTO Criteria (GetValueN)VALUES " & "2" & ";"
DoCmd.RunSQL (strSQL)

My table is [Criteria]
The field is [GetValueN] and it's numeric
The field name is [COMPETENCY_ID] and the Control Source is
[Competency Identifier]

Help please?

The VALUES list should be surrounded by parenthesis...

Set DB = CurrentDb
strSQL = "INSERT INTO Criteria (GetValueN) VALUES(" & "2" & ");"
DoCmd.RunSQL (strSQL)