wearing out my welcome...

Can someone direct me how to accomplish a very simple task...namely...

If I have an opening form, how do I prompt someone to logon, retain that data as a public variable, and be able to refer to it as a condition during that session of accessing whatever...?

I'm fairly new to access myself so I'd be interested in ways of doing this.

I would call a pop-up form as part of the form open procedure.

To sotre variables across forms a create a module called GlobalVar. Inside this module is a procedure called GlobalLoad. Put nothing in this procedure. Above the procedure I declare global variables e.g.

Public gbl_str_MyString as String

Within the VBA for the form, in this case the form open event, make a call to GlobalLoad:

Call GlobalLoad

This ensures that the module AND THE GLOBALY DECALRAED VARIABLES are in the workspace (I've had some problems without the call).

Then use the vaiable as you would any other! e.g.

gbl_str_MyString = "Whatever"
or gbl_boo_PaswordVerified = True

hth

HiArt