Stupid request

[Shaun Allan]

I can't believe I can't do this, but my mind has gone
blank, so I've forgotten the simplest thing!

I need to check a name in a field in a table. The table
has only one record, and in one field is the name of the
current boss/deputy.

I have some code which limits access to certain controls
etc. based on who is the boss or deputy. That name is
stored in a table. Nothing fancy. And I need to say : if
username is "Garry" or username is "John" or username is
deputy-name-in-admin-database-field then blahblah

 

[tina]

see the DLookup() function in Help.

 

[Shaun Allan]

Perfect! Thanks!

-----Original Message-----
If DLookup("[FieldName]","TableName") = "Whatever" then

Do Something

End If

I can't believe I can't do this, but my mind has gone
blank, so I've forgotten the simplest thing!

I need to check a name in a field in a table. The table
has only one record, and in one field is the name of the
current boss/deputy.

I have some code which limits access to certain controls
etc. based on who is the boss or deputy. That name is
stored in a table. Nothing fancy. And I need to say : if
username is "Garry" or username is "John" or username is
deputy-name-in-admin-database-field then blahblah

.