INSERT code not working

[krc777]

Hello-
I've tried everything I can think of to get this code to run.

currrentdb.Execute "INSERT into MainRptDataASD (PlanName) VALUES ('Test')"

I've tried ' "& test &" " too. Test and PlanName are both string fields.


It works fine in the SQL app and inserts a record but I can't get it to work inside Access code.

k

 

[Bat17]

do you get an error message? depending on your version of access you may need to set a reference to DAO.
In any module Tools>references...

Peter

 

[modest]

well two errors, you need to keep the spacing between the variable, string, and the ampersand

" & test & " --- if test is a textbox on the form

but the real error is in your function call, you have too many "r"s

CurrentDb, not CurrrentDb

 

[krc777]

I looked at it so long I couldn't see it.
Thanks so much!
k