For how long access keeps a declared variable value?

[arkadis]

If i have a variable in a module "Public UserID As Long"
and i declarer it through login form @ startup UserID = Me.UserID.

Will Access keep this value during all session until i close the db?

If i understand correctly..

1) If i declare it in a MODULE then i can use it during all session until i close the db.
2) If i declare it in a FORM then i can use it until i close the form.

Am i rite?

Thanks!

 

[arnelgp]

you are correct.

 

[CJ_London]

until i close the db.

or the code is stopped - e.g. through an unhandled error