Storing a Per User Per Session Variable

[DawnTreader]

Hello All

is there a way to store a number, generated by a table autonumber when a
user "logs in", into a VBA variable of some kind that i can call again when
the user is about to exit? would that be more efficient than storing it in a
text box on my main always open form?

 

[Douglas J. Steele]

Storing it in a text box on an always open form is actually better, since
public variables can get reset by errors.

 

[Daniel Pineault]

Yes, anything (or almost anything) is possible, but perhaps if you explained
what you are trying to accomplish we could guide you.

What you are talking about are commonly referred to as Global Variables.
Take a look at http://www.blueclaw-db.com/access_database_global_variable.htm
to learn a little more on the matter.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.