Update Checkbox Value with IF statement

[excellenthelp]

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:

        
        NoUser = DLookup("[UserID]", "[TABLE]")        If NoUser <> "ME" Then
            [AllowLogin] = 0
        End If

I am sure this is very simple to solve... I might need a gallon of coffee.

Thanks!

[pbaldy]

For starters, without a criteria your DLookup() will always return the first record in the table:

DLookup Usage Samples