Copy information from one form to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JoeP - 19 Jul 2007 21:58 GMT

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

Reply to this Message

pietlinden@hotmail.com - 20 Jul 2007 03:13 GMT

> 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
[quoted text clipped - 6 lines]
>
> 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.

Reply to this Message

JoeP - 20 Jul 2007 10:34 GMT

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.

> > 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
[quoted text clipped - 14 lines]
> always a bad idea. You can use a combobox with hidden columns to
> populate the second form.

Reply to this Message