i am using Access as a front end on our MSSQL server. i have 2 files - a test and production. in the test file i have 3 forms and global module. the first two forms (a form and a subform) are used to select which area you would like to go. when you select (click) on the area in the subform, it stores a room number in a global variable. the global variable is used in the third form. this works perfectly in the test file.
i imported the 3 forms and the global module into my production file. when i debug, the global variable has a value on the first form/subform. the value is lost when the third form is loaded. for some reason it does not work in the production file.
what is happening to my global variable? why is it being lost?
i imported the 3 forms and the global module into my production file. when i debug, the global variable has a value on the first form/subform. the value is lost when the third form is loaded. for some reason it does not work in the production file.
what is happening to my global variable? why is it being lost?
