i posted similar questions in the MS Access Forms forum with no help....hopefully someone here can lend some guidance.
i have two files: "test" and "master". in the test file i create new forms, queries, etc and if they work properly, i import them into the master file.
recently, i created 2 forms in test - one form list all rooms for all buildings we manage. when the user selects the room in the proper building they double-click the room number and form 2 loads - the room number is stored in a global variable (module) and is used in the second form. on this form the necessary information is entered for this room.
throughout all testing and debugging, this worked in the test file. in order to make this available for use by our employees, i needed to import all necessary information (2 forms and the module) into the master file. i've done this numerous times before with no problem. this time, however, it does not work after i imported it to master. the global variable (room number) is not being passed properly and is not available in the second forms.
i did nothing to the forms but import them. the forms still work in test but nothing in the master file...does anyone know what might cause this or how to solve this dilemma?
i have two files: "test" and "master". in the test file i create new forms, queries, etc and if they work properly, i import them into the master file.
recently, i created 2 forms in test - one form list all rooms for all buildings we manage. when the user selects the room in the proper building they double-click the room number and form 2 loads - the room number is stored in a global variable (module) and is used in the second form. on this form the necessary information is entered for this room.
throughout all testing and debugging, this worked in the test file. in order to make this available for use by our employees, i needed to import all necessary information (2 forms and the module) into the master file. i've done this numerous times before with no problem. this time, however, it does not work after i imported it to master. the global variable (room number) is not being passed properly and is not available in the second forms.
i did nothing to the forms but import them. the forms still work in test but nothing in the master file...does anyone know what might cause this or how to solve this dilemma?
