How to keep the value of the variable saved unless database is closed?

[Jawad77]

I am assigning a value to the variable in a subprocedure behind my second form. When I move to my first form, value of the variable is gone. I like to save this value even when I navigate from my second form to my first form.

I tried to define my variable as static but it doesn't work.

Any ideas/thoughts how to accomplish this? Thanks!

Jay

 

[RoyVidar]

A (real) public variable is declared in the declaration section of a standard module (i e - in VBE Insert | Module, then right after the lines Option Compare Database and Option Explicit (you have the last one too, haven't you?), declare the public:

[tt]public gmyvariable as <yourdatatype>[/tt]

Roy-Vidar

 

[Jawad77]

Thanks Roy,

It Worked!