Access a variable (global?) in any form (MS Access) 1

[xenofoob]

Heya,

Is there any way to access a variable in a form where the variable is not created?

This is my layout (simply explained):

mainform:
Dim bLogin As Boolean

loginform:
MsgBox bLogin (result: empty msgbox)

The mainform is being closed after loginform has been opened.

Is there anyway to access the variable bLogin as a GLOBAL orsomething?

Erik.

 

[RoyVidar]

To create a true public variable, declare it in the declaration section (at the top, right after the option compare database/option explicit lines) of a standard module (not a forms/reports module, but in VBE - Tools | Insert | Module) using the public keyword:

[tt]public gfLogin as Boolean[/tt]

Else, the scope of a form variable is whithin either the routine (sub/function) if it's declared within it, or the form if it's declared in the declaration section (with the public keyword).

If it's declared with the public keyword a forms declaration section, then it is accessible as long as the form is open, just as any form property thru for instance:

[tt]msgbox forms("frmMain").myformpublic[/tt]

For Access questions, perhaps have a look at the Access fora (there's seven of them here...)

Roy-Vidar

 

[xenofoob]

GREAT!

The solution for my problem was to insert

public gfLogin as Boolean

into the module. Tried this before only without the public.

Thanks for the quick reply