transfer form data to a different form

[lleemon]

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

[M Owen]

Yes. Just copy them.

[lleemon]

Okay, does anyone have a better answer then just copy them? Looking for a way using code, like a macro function.

[WorkHorse]

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.

This example copies the text from Text0 in Form1 to Text0 in Form2 when the user clicks on a command button.

Private Sub Command2_Click()
    Forms![Form2]!Text0 = Forms![Form1]!Text0
End Sub

[biswajitdas]

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