DoCmd.RunSQL problem

[JB83]

Dear reader(s),

I have a problem with DoCmd.RunSQL: when I want to add a record in a table with a WHERE-clause I get a syntax error, and I don't know how to solve the problem.

DoCmd.RunSQL ("INSERT INTO [tblReasons] (Reason1, Reason2, Reason3, Reason4, Reason5, Reason6) 
SELECT " & defReason & " , " & defReason & " , " & defReason & ", " & defReason & " , " & defReason & " , " & defReason & " WHERE docNumber = txtDocNumber.Value")

Thanks in advance,

Jochen. --------------------------------------------------------------------------------
It never hurts to help and it never helps to hurt.

 

[bjpearce]

Try
.................................
SELECT " & defReason & " , " & defReason & " , " & defReason & ", " & defReason & " , " & defReason & " , " & defReason & " WHERE docNumber = " & txtDocNumber & &quot

 

[ajdesalvo]

JB83,

You really shouldn't cross-post your questions, I also have answered this in your thread: thread701-477265

It may be helpful to read the thread that JeremyNYC posted on how to get good answers thread181-473997.

Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[JB83]

Thanks for all the help, but I found a solution myself.

Keep up the good work!

--------------------------------------------------------------------------------
It never hurts to help and it never helps to hurt.