Global variables

[dowingc]

Trying to get a variable on one form to work on another. I have one form set a value on a variable, then the user is to click a button which opens another form. Then I want to apply that variable in this new form. Unfortunately I cannot figure out how to do this in Access VBA. I have tried making a module with a line:

public vartype(cnumber) as integer

and then using 'cnumber' throughout the program, and this doesn't work. :x Please show me the light!

Thanks in advance.

Chris

 

[Dugantrain]

Maybe you should put this code in its own module rather than a form module. I don't work with Public variables too much, so I don't know the answer. Most of the Access users on this site are Beginner, Intermediate, or Semi-Advanced and only a few work with VBA. If there is no answer to your question, I'd go to

http://www.access-programmers.co.uk/

and look through their Archives (you can post a new topic, but be careful as they get a little testy about answering new posts that have already been explored :wink: ).

*I looked through their Archives and found this:

In order to create a Global Variable, substitute the Dim Keyword with Public. Make your Declaraion in the General Declarations section of a Module. And away you go...

But it sounds like you did that?!