Filling control in a form from a calling form

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

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
________________________
 
Got it! Thanks!

Gary Miller said:
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
________________________
Click to expand...
 
Back
Top