Log in Form select query

  • Thread starter Thread starter Mart
  • Start date Start date
M

Mart

I've done this before using th DLOOKUP function.

The users entered an ID in a txt box. The after update of
the txt box use the dlookup to check the user existed.

You may want to skip the whole process. What I use now is
a list of IDs. They are stored in the Environ collection.

Environ("UserName") will show the current user.

Try entering Environ("UserName") as the critera in a query
looking at a table of user ids or use the dlookup to do
this when you open the first form the uses see, closing
the form if it cannot find the user.
 
That sounds good.
Just two questions then.
What is an Environ collection and how do I add a list of
IDs to it?

Thanks
G
 
Back
Top