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

On Jul 19, 3:58 pm, JoeP <J...@discussions.microsoft.com> wrote:
> 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.

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.

"(E-Mail Removed)" wrote:

> On Jul 19, 3:58 pm, JoeP <J...@discussions.microsoft.com> wrote:
> > 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.
>
>