Inserting data into a popup form

  • Thread starter Thread starter Rachel
  • Start date Start date
R

Rachel

When you check the checkbox on one form, a new form pops
up.

I need two fields from the original form to carry over
into a new inserted record on the popup form. How do I do
that?

Thanks,
Rachel
 
If the popup form is non-modal, you can put code similar to
the following directly afetr the DoCmd.OpenForm statement

Forms!popupFormName.controlName = Me.controlName1

If the popup form is modal, then you can use the OpenArgs
parameter of the DoCmd.OpenForm statement to pass the
values to the popup form, then put code into that form's
Load eventhandler to populate the controls.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top