syntax error

[pokdbz]

I am getting a syntax error on this statement
Dim strSQL As String

strSQL = "INSERT INTO " & Genetic_ID_number & " ([" & geneticIDnum & "])
SELECT " & RandomNum & " AS RandomNum;"
CurrentDb.Execute strSQL

What I am trying to do is to insert a RandomNum into the Genetic_ID_number
table field geneticIDnum.

What is the problem with this statement

 

[Dirk Goldgar]

I am getting a syntax error on this statement
Dim strSQL As String

strSQL = "INSERT INTO " & Genetic_ID_number & " ([" & geneticIDnum &
"]) SELECT " & RandomNum & " AS RandomNum;"
CurrentDb.Execute strSQL

What I am trying to do is to insert a RandomNum into the
Genetic_ID_number table field geneticIDnum.

What is the problem with this statement

The table is named "Genetic_ID_number" and the field in the table is
named "geneticIDnum"? You want to insert one record with a value for
[geneticIDnum] taken from the variable RandomNum? Try this:

strSQL = "INSERT INTO Genetic_ID_number (geneticIDnum) " & _
"VALUES (" & RandomNum & ");"

 

[pokdbz]

worked perfect thanks for the help

I am getting a syntax error on this statement
Dim strSQL As String

strSQL = "INSERT INTO " & Genetic_ID_number & " ([" & geneticIDnum &
"]) SELECT " & RandomNum & " AS RandomNum;"
CurrentDb.Execute strSQL

What I am trying to do is to insert a RandomNum into the
Genetic_ID_number table field geneticIDnum.

What is the problem with this statement

The table is named "Genetic_ID_number" and the field in the table is
named "geneticIDnum"? You want to insert one record with a value for
[geneticIDnum] taken from the variable RandomNum? Try this:

strSQL = "INSERT INTO Genetic_ID_number (geneticIDnum) " & _
"VALUES (" & RandomNum & ");"

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)