I have the below code. I have looked over this time and time again. Not quite sure what is throwing the error message. A fresh set of eyes would help. Thank you.
Code:
Dim varUser As String
Dim varDate
Dim varEntityID
varEntityID = Form_AA_frmBankGarn.txtPriEntityID.Value
varUser = Form_FrmMain.RV.Value
varDate = Now()
mySQL = "UPDATE LevyTable SET [LastUpdateUser]= varuser WHERE [PriEntityID]='" & varEntityID & "'"
CurrentDb.Execute mySQL, dbFailOnError
Keep getting the error message:
"Run-time error '3061':
Too few parameters. Expected 1."