Still Confused with Variable transfer form to form

sebastopol123

New member
Local time
Today, 12:27
Joined
Sep 5, 2007
Messages
5
When working in form1, I open form2. Here I enter data in a text box. I close form2 and wish to enter the data from form2 into a text box in form1. It was suggested I use Forms!Formname!formcontrol, but I get nothing. Is this because I closed form2? If I leave form2 open how do I get to form1, and how do I close form2 from form1.
Thanks in advance
 
I would think using a command button or the OnClose event... would work.. to copy the info.... Forms!Formname2!formcontrol = Forms!Formname1!formcontrol
But the question comes to mind....why? Is form 2 an unbound textbox? Calculation? If it is bound why duplicate info? If it is saved into one table you do not want it saved to another table.
 
Form 2 is unbound as it can either select from a list or have input from the user. The input will be in text and may exceed 255. Hence there may be, or may not be duplication depending on the 'problem' input on from2. This outlyer would not be repeated in the same manner so no reason to keep it in another table.
At present the test program has a control button that opens form2, and form2 has a control button that closes form2.
Does this explain or help my solution?
Thanks
 

Users who are viewing this thread

Back
Top Bottom