Syntax Error in code I wrote

[SanHall]

Can someone tell me what is wrong with this statement. I get an error message stating Run Time erro 3134 Syntax error in statement. Not sure what to do. Can anyone help??

DoCmd.RunSQL "INSERT INTO [tblProductionInformation]![cur] VALUES Forms![frmProductionEntry]![cur]);"

 

[The_Doc_Man]

That pesky little 's' at the end of your "Forms![...." is the culprit.

If this code is behind the form you really wanted to use, try "Me![cur]"