I want to store a value to a variable entered in a form that is loaded on startup and keep this value on memory unitl the application closes so that another form uses this value.
I used a public declaration on the first form but the value remains only while the form is open.
Do you have any suggestions?

Well, here are two choices.

You can create a form with a textbox that holds the data in there and keep this form open but hidden so that you can use the variable in other forms.

You can create a global variable and assign it the value and it'll hold the value as long as the database is open. Which form is open doesn't matter.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Considering the second choice, where do I have to declare the global variable so that it maintains its value?

Click the Module tab on your database and create and save a new module. Below the "Option Compare Database" declare your variable, e.g.

   Public strMyVariable As String

Then set the string in one of your forms as needed. If you're assigning a global variable that's a number that's also constant, you can set the number right up front in the new module, e.g.

   Public Const intMyVariable as Integer = 256

Once you declare a variable as constant, you cannot change it in any form.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

This seems that it doesn't work. As soon as the form that assigns the value to the variable closes the value is set to null.
If I end up using the second choice (with the textbox), how do I make the form hidden?

That's odd... it shouldn't. Did you assign the global variable in its own module from the Module tab or did you just open a form and go to the VB code area and put it there? Do the former, not the latter.

To hide a form, you can set it's Me.Visible = False or merely keep the other forms maximized and open over it at all times.





Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Yes, I created a new module. This is all it contains

Option Compare Database
Option Explicit
Public intCurrentUser As Integer

Anyway, I solved my problem using the textbox on the hidden form.

I appreciate your help. Thank you for your time, SerranoG.