Copy information from one form to another

[JoeP]

I have a form called Participant where I enter a person's information. After
I enter the information I want to go to another form called Registration and
register them in a course.
Is there a method to take the information from the Participant form click a
button to open the Registration form and have that person's record
automatically be active in the Name field on the Registration form.

thanks for any help.

JoeP

 

[pietlinden]

I have a form called Participant where I enter a person's information. After
I enter the information I want to go to another form called Registration and
register them in a course.
Is there a method to take the information from the Participant form click a
button to open the Registration form and have that person's record
automatically be active in the Name field on the Registration form.

thanks for any help.

JoeP

If the forms are both open at the same time, sure.

me.MyControl=Forms!OtherForm!OtherControl

But why are you doing this? copying redundant data around is almost
always a bad idea. You can use a combobox with hidden columns to
populate the second form.

 

[JoeP]

Thanks for the information. The reason I am doing it so that when I open the
registration form I don't have to look up the participant. It just will save
me a step in the registration process.