I have an insert query which is suposse to insert the value of stStatus(string) Into table pSWrdAteemptTbl, colum [status]
And when I try to run it (onclick) I get "Argument not optional" and highlghts DoCmd.RunSQL, isn't Inert an action so i can use DOCmd.RunSQL?
[VBA]
DoCmd.RunSQL = "Insert InTo [PSwrdAttemptTbl] (Status)" _
& "Values (StStatus);"
[/VBA]
If I can't run DoCmdRunSQL, are my only options to create a query to pass the value or pass though a textbox?