Trouble With Variable holding Value

[michaelb]

I have a table, TblCounter, that I am using to setup a counter that is incremented by one each time it is accessed. I store the counter in a variable (myCntVar) which I want to store in a record that already exist in one table (Table A). I also need to create a new record in a different table (Table B) and store the counter in the new record. I am able to store the counter in (myCntVar) in one module, which I tested by putting the variable in a Msgbox (myCntVar) statement which displayed in a form. When (myCntVar) is placed in another module, it does not hold the value place in it. I defined the (myCntVar) as Public at the beginning of a module before the first Procedure so I am able to use it. My Problem is it does not hold the value placed in it. Please Help!!! Thanks

[pbaldy]

It sounds like a scope problem. To be accessible throughout the application, the variable should be declared in a standard module, not the module behind a form or report. Is it?

[michaelb]

It sounds like a scope problem. To be accessible throughout the application, the variable should be declared in a standard module, not the module behind a form or report. Is it?

Thanks pbaldy. Your solution worked for me...

michaelb

[pbaldy]

Happy to help, and welcome to the site by the way!