Passing Variable - Form must be open?

kbreiss

Registered User.
Local time
Today, 21:52
Joined
Oct 1, 2002
Messages
228
I'm attempting to pass a variable from form to form...I'm having trouble doing it...I checked the forum and read a little that the form I'm passing it from must stay open...is this correct? I have my variable as: Public strUserName as String. It does work fine if I leave the form open then I can pass it...

But I want to be able to close the form and still pass the variable...How can this be acheived?

Thanks in advance.
Kacy
________
Video review
 
Last edited:
You will need to create a Global Variable in a standard module in order to close the form.
 
Kacy,

You can keep the form open and just minimize/hide it.

You can store the value in a table.

You can store the value in a Public variable in a Module,
NOT a form module though. If you wish to reference it
in a query, you'll need to retrieve it with a Public
Function.

Just some of your options.
Wayne
 
Thanks

Thanks for the suggestions....I didn't realize when you declare a Public variable it had to be in a module...I were declaring them as public within the forms itself...thanks again..

Kacy
________
PiercingsPussy
 
Last edited:

Users who are viewing this thread

Back
Top Bottom