Hi!
Global variables should maintain their value while the application is running code. If, for any reason, the Db stops running code (such as going into any design view or unhandled errors) then the global variables lose their values. I usually set up a form that I keep my 'global variables' on in text boxes.
hth
Jeff Bridgham
bridgham@purdue.edu