I have a form with a command button on it.

The command button opwns another form and I'd like some of the data from the
1st form to be inserted into some of the controls on the 2nd form when it
opens.

The second form is unbound.

Do I need to make a temp table?

Thanks.

No, you shouldn't need to make a temp table as you can do
this from the code that opens the form. You can do something
like this using your correct names, of course...

DoCmd.OpenForm "Form2Name"

Forms!frmForm2Name!1stControl = Me!1stControl
Forms!frmForm2Name!2stControl = Me!2stControl
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
"SAC" <(E-Mail Removed)> wrote in message
news:uX$(E-Mail Removed)...
> I have a form with a command button on it.
>
> The command button opwns another form and I'd like some of
the data from the
> 1st form to be inserted into some of the controls on the
2nd form when it
> opens.
>
> The second form is unbound.
>
> Do I need to make a temp table?
>
> Thanks.
>
>
>

Got it! Thanks!

"Gary Miller" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> No, you shouldn't need to make a temp table as you can do
> this from the code that opens the form. You can do something
> like this using your correct names, of course...
>
> DoCmd.OpenForm "Form2Name"
>
> Forms!frmForm2Name!1stControl = Me!1stControl
> Forms!frmForm2Name!2stControl = Me!2stControl
> --
>
> Gary Miller
> Gary Miller Computer Services
> Sisters, OR
> ________________________
> "SAC" <(E-Mail Removed)> wrote in message
> news:uX$(E-Mail Removed)...
> > I have a form with a command button on it.
> >
> > The command button opwns another form and I'd like some of
> the data from the
> > 1st form to be inserted into some of the controls on the
> 2nd form when it
> > opens.
> >
> > The second form is unbound.
> >
> > Do I need to make a temp table?
> >
> > Thanks.
> >
> >
> >
>
>