Search results

Tried it, hasn't worked

I am setting the fields to nothing if the preceding "IF" statement evaluates to "FALSE". So if the field "ME.Active" (which is a check box) is false (unchecked) then this sql statement should set all the fields listed (lead, backup, sLead, sBackup) from table "Country" to nothing, where the...

If Me.Active = False Then If MsgBox("Are you sure you want to inactivate the selected user", vbYesNo) = vbYes Then DoCmd.RunSQL "Update Country " & _ "INNER JOIN tblUser ON [Country].[Lead] = [tblUser].[UserID]" & _ "SET [Country].[Lead] = ," & _ "[Country].[BackUp] = ," & _ "[Country].[sLead] =...