Resolved: Quick question regarding Access 2000 forms

[Hizaed]

Hello all,

Here we go. FormA user enters login info once the login is entered and the ok button pressed the form loads the data to memory and then closes itself. Is the data that was loaded lost when the form closes? Also, FormB runs a script that uses the login info that FormA loaded to memory. Would I have needed to load that login info as public? Or is a Dim statement sufficient.

In summation, if a form is closed but the database remains open do I lose the data that the code within that form loaded to memory and therefore it would be better just change the form to visible = false when the info is loaded to memory? And When I need to share info between two or more forms does it need to be loaded as public or is the Dim statement sufficient? Thanks! I apologize if my terminology is incorrect.

Hizaed