I have two MS Access forms (form1, form2) with textboxes in them. Is it possible to have one form pass the value from form1 textbox to form2 textbox?
Thanks advance for your help.
LEe
Printable View
I have two MS Access forms (form1, form2) with textboxes in them. Is it possible to have one form pass the value from form1 textbox to form2 textbox?
Thanks advance for your help.
LEe
Yes. Just copy them.
Okay, does anyone have a better answer then just copy them? Looking for a way using code, like a macro function.
This example copies the text from Text0 in Form1 to Text0 in Form2 when the user clicks on a command button.Quote:
Originally posted by lleemon
Okay, does anyone have a better answer then just copy them? Looking for a way using code, like a macro function.
:)VB Code:
Private Sub Command2_Click() Forms![Form2]!Text0 = Forms![Form1]!Text0 End Sub
The best Idea is Make a global variable
and store the value of form1
and then when you show second form then display the value in the second one.
it reduce your memory space.and also no need to show the two form at a time
Biswajit das