Declare a Global Variable and Use it on Forms

[jackkent]

I thought this would be a simple process but I'm having trouble with it:
I set up the following in a module:

Option Compare Database
Global gbl_user_name As String
Public Function get_global(gbl_user_name As String) As Variant
gbl_user_name = "Jack Sprat"
End Function

When I try to set the contents of a text box (on a form) to gbl_user_name



Me.txt_user_name.Value = gbl_user_name

I get the following error message.

Expected variable or procedure, not module.

Please help if you can.

Thanks,

jackkent

[pbaldy]

Edit: misread the question. Where is that declared? I do this type of thing in a standard module:

Public lngResNum As Long

[jackkent]

Is in a standard module (not a class module).

[pbaldy]

Oh, and make sure the module itself isn't named the same as either the function or the variable.

[jackkent]

Still having a problem... Renamed module to mod_user_name

Option Compare Database
Global gbl_user_name As String
Public Function get_global(gv_user_name As String) As Variant
gv_user_name = "Jack Sprat"
End Function

No error message but blank text box.

On form:
Me.txt_user_name = gv_user_name

[pbaldy]

You would have to execute that "get_global" function at some point to populate the variable; are you? Also, unless it's a typo, you have two different function names there.

[jackkent]

Sorry, I'm a novice at Access... Not sure what you mean by executing the function. Can you offer a suggestion on how to code/execute? BTW, love the Who is John Galt. I've read everything I could get my hands on by AR. Huge fan of Objectivism.

[weekend00]

put a line of code in the form_load event:
private sub form_load()
gbl_user_name="jack Sprat"
end sub

[pbaldy]

In your code you have this function that sets the value of the variable:

Public Function get_global(gv_user_name As String) As Variant
gv_user_name = "Jack Sprat"
End Function

That function will not execute unless you tell it to. Is there a reason you're using it? As written, there's no reason for the input parameter. Maybe you can clarify the overall goal here.

I like most of AR's writing, but Atlas Shrugged is probably my favorite. Sadly, it's probably more relevant now than ever.

[jackkent]

Thanks all. I believe I found better way of handling (i.e. Temp
Vars). This way the global variable is never destroyed in the case of an error. Again, thanks all.