Hello Accessers,
What is the correct way to update the checkbox value in a table with an IF statement?
Desired Result:
Check if UserID is not 'ME'
If it is not 'ME' then uncheck the box in the table.
My current faulty code below:
I am sure this is very simple to solve... I might need a gallon of coffee.Code:NoUser = DLookup("[UserID]", "[TABLE]") If NoUser <> "ME" Then [AllowLogin] = 0 End If
Thanks!