VBA - Passing variable to next form

[RufussMcGee]

How do I pass variables from one form to the next?

Thanks

 

[TCARPENTER]

Hi Rufuss,

Depends. There's lots of ways to do this, if you are running the code from a module, and your variable is defined within your module, then your form should be able to access this variable, if the variable is defined within the code portion of your first module, you will need to pass it as a variable to your form open/load event.

HTH
Todd

 

[borgunit]

Another option is to make the variable global in scope and have it available to any module also. Another option.