Inserting data into a popup form

[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

 

[Gerald Stanley]

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

 

[Rachel]

Can anyone give me an example of this?

Thanks,
Rachel