How to find record in table and use one of its field for an if statement

[behnam]

Hi guys,

I have a table called login and inside that table is three columns: username, password and admin. I have the username saved in a global variable called GsUser. How can i find the record in that table with the same Username as the string stored in GsUser and use that record for an if statement which sees if the value of the admin column is "Yes". Im trying to do it using VBA. Im not using a form where everything is bounded. Thanks.​

 

[Cotty42]

Try using the DLookup function.

regards
Dave

 

[pr2-eugin]

You can simply use a DLookup to get the value.

someVariable = Nz(DLookup("admin", "login", "username = ' & GsUser & '"), False)