vba, variable, and access

[stroll]

Hi,

I am a new user of vba.
Is there a way of permanently storing varibles in vba?(without using a table)

I would like to create a variable which is updated once a year. Throughout the year, this number would be used in a subtraction process to create another number. At the end of the year, this number would then be updated and used accordingly.

The application using this number would be closed when not in use.

Thanks
Ryan [sig][/sig]

 

[swilliams]

If your application is going to be closed when not in use, any variables that you have will be lost. Therefore, use a table to do what you want.

Is there any reason why you don't want to use a table?

Simon [sig][/sig]

 

[stroll]

Hi,

I have decided to store it in a table. Can you tell me how to reference the field in the table within a form?

Thanks
Ryan [sig][/sig]