Keeping a variable in scope

[azizrasul]

Hi, This is my first post on this forum.

If I run some code triggered by say pressing a command button, call it cmd1, and I have a variable that takes on a value when the function comes to an end.
How do I retrieve this value from the same variable when I run a different code behind cmd2?
In other words, how do I retain the variable value in scope when I run different functions triggered by separate events?

[ranman256]

global variables exist everywhere, all forms , all code modules.
GLOBAL gsUserID as string

local variables exist only in the sub/function and nowhere else.
modular vars exist in the entire form or vb module if you delare above all the subs: which is what you want

'internal form code
private msName as string

sub cmd1_click()
  msName = "Bob"
end sub

sub cmd2_click()
  msgbox   msName 
end sub

[Minty]

How long do you want the variable scope to last?

Everywhere whilst the db is running - declare it as a Public in a separate module, note this will not be set if your code crashes.
Just while the form is open - declare it before any other code in the forms module - Directly below Option Explicit

[azizrasul]

When I run the code on a user form with 2 command buttons and declare the variable outside of the functions as mentioned, then it's fine. However when I do the same by running the 2 functions separately via test modules, then the second function doesn't remember the value when the first function was run.

I want the variable to last when the second function finishes.

[Minty]

That sounds like you are declaring the variable in the forms module.

Make a new Module - call it modGlobals

Declare your Public variables in that.
Save it, and restart you database.

[Minty]

Is this related to this thread https://www.access-programmers.co.uk...22#post1617022 by any chance?

[azizrasul]

It is Yes.

How would you declare the variable in modGlobals? The variable name is

Public MyDict As Dictionary

I have tried replacing Public with Global, but that doesn't make a difference.

[Minty]

I'm also going to guess that this might be in Excel then ?
I'm not sure you can declare a Dictionary like that.

[azizrasul]

Yes, the code is written in Excel.

[Micron]

maybe look here
https://support.microsoft.com/en-ca/...r-applications

or any one of thousands of places where this is well documented?