Log in Form select query

[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.

 

[Gavin Webb]

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