Passing value from closed form to open form

[gmazza via AccessMonster.com]

Hey there,
I have a form which when the user changes a certain field, another form opens
asking for their password and another text box for the reason for the change.
If the password is correct I close this form and go back to the original form,
problem is, I need that value in the text box on the form now closed.
I have a Audit Trail table that gets Inserted into on the Before Update Event
of the first form. I need that value on the 2nd form to also go inot my Audit
Trail table under the same record as the change made to the first form from
the beginning of my post.
Hope that makes sense, thanks for the help!

 

[Stefan Hoffmann]

hi,

I have a form which when the user changes a certain field, another form opens
asking for their password and another text box for the reason for the change.
If the password is correct I close this form and go back to the original form,
problem is, I need that value in the text box on the form now closed.

Hide the form instead of closing it, then you can read the values and
close it from your other one.


mfG
--> stefan <--

 

[gmazza via AccessMonster.com]

I don't want to hide it, I need it closed for other reasons.
Any other ideas?
Thanks!

 

[KARL DEWEY]

Once you close it the data is goooonnneeee.

I don't want to hide it, I need it closed for other reasons.
Any other ideas?
Thanks!

 

[Kiran]

Assign the value of the Text to a global variable. Use the global variable
afterwards.


Kiran