Stupid request

  • Thread starter Thread starter Shaun Allan
  • Start date Start date
S

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
 
Perfect! Thanks!
-----Original Message-----
If DLookup("[FieldName]","TableName") = "Whatever" then

Do Something

End If

Shaun Allan said:
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
Click to expand...
.
Click to expand...
 
Back
Top