How to pass on current record info without keeping any forms open?

[TimSlape]

The key field ("BusinessName&quotis entered/appears on the first form, and is needed throughout the app, but I don't want to keep first form open. I've tried declaring it as Global, but don't know how so it doesn't work. Is that the right approach?

This is what works now, but it requires "Form1" to remain open all the time. Each form uses a different table with BusinessName as the key, and the reports use queries.

If IsNull(Me!BusinessName) Then

Me!BusinessName = Forms("Form1&quot! BusinessName.Value

End If

 

[THoey]

How about just hiding the form? Set the forms visible property to false... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[TimSlape]

Thanks Terry, but all I needed was a global variable that picked up the key field data on it's first entry, just didn't know where to put it. Do now...