Search results

Thanks for your reply. I changed it to: MySql = "UPDATE " & RecordSourceName & " SET " & RecordSourceName & "." & FieldName & " = " & Switch1 & ";" but I'm still getting the same error.

I'm trying to use the code you posted... it's just what I was looking for. But, Im getting a runtime error '3144' Syntax error in UPDATE statement. My code is below. Can you spot the problem? Function TickOnOff(FormName As String, FieldName As String, TickBoxName As String) Dim...