Global Variable Nightmare

[wornwillie]

High there!! Would you mind helping me with an issue that I am having with global variables?

I have Defined a bunch of Global Variables:

Option Compare Database
Option Explicit
Public Elig_Specification_Name As String
Public Elig_File_Type As String

They are in a form called form_Choose Client.

I go into another form and attempt to use them by either [form_Choose Client].Elig_File_type
or I have tried to use Elig_File_type.

I am getting a NULL instead of the string that I have set it equal to.

Could you help?

Thanks

 

[wornwillie]

I figured out that I had to have the form - opened that has the global declarations in it. Correct?

Can I have a hidden form with the declarations in it that is alway open?

 

[Jack Cowley]

You have to declare your variables in a module, not in the class module of a form....