PDA

View Full Version : Solved: Annoying update Query



Trevor
04-10-2008, 01:23 PM
I am trying to run an undate query that worked, untill I added the line
formName = "Account Log" then I keep getting expected end of statment error account log is a value in a field

DoCmd.RunSQL "UPDATE IndividualSettingsTbl SET IndividualSettingsTbl.FormName = '" & stBoxForm & "' " & _
"Where IndividualSettingsTbl.UserName = '" & AccountName & "' And IndividualSettingsTbl.FormName = "Account Log" ;"

Thanks for Helpin
I have tried ""Account Log"" , "account Log" & ;" , """Account Log"" &;"
all with out luck

Trevor
04-10-2008, 01:37 PM
solved just need single quotes arount account log