transfer form data to a different form

[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