Variable defined in Public Sub does not appear in another Private Sub

[Phil H]

In a Public Sub, I Dimension a String variable called Course and place a value in it. I confirmed the value is actually there via the debugger. When I refer to the variable in another Private Sub it recognizes the variable name OK, but the field is empty. What have I done wrong???


Thanks for any help...Phil H

[June7]

Variable is declared in module header?
Do you have Option Explicit in every module header?

If you want to provide db for analysis, follow instructions at bottom of my post.

[Welshgasman]

I *thought* the Sub or Function was Public?, not the variables dimmed within them?
I put any I need Public at the top of a module, right after the Option statements.

[moke123]

You may want to look around for articles that explain "Scope"

here's one to get you started https://docs.microsoft.com/en-us/off...and-visibility

[davegri]

For a public variable it's

Public course as string

not

Dim course as string


Careful! If you Dim the variable again in a local procedure, the procedure will use that variable instead of the public one.

[Phil H]

In a Public Sub, I Dimension a String variable called Course and place a value in it. I confirmed the value is actually there via the debugger. When I refer to the variable in another Private Sub it recognizes the variable name OK, but the field is empty. What have I done wrong???
Thanks for any help...Phil H

I would mark this as "solved" but I can't figure out how to do that. Actually, I didn't get my problem solved, but I believe my problem has to do with the "Scope" issue and my lack of understanding of module versus procedure, etc. In the end, I found a work-around. But thanks to all.

[Welshgasman]

Look at thread tools top right in the header of the thread.
To help others, please post how you solved your problem.