Open second form with customer data from first

[KerryL]

After entering a bunch of customer data on a form called frmCustomerData, the user can click a button called cmdEnterRequest. This button is supposed to save the data on frmCustomerData and close that form, then open another form called frmCustomerRequests WITH the name/address data from the first form to allow the user to enter the request detail.

For example, if frmCustomerData contains:

James Smith
169 Main Street
Tulsa, OK 60045
(etc, etc, etc)

Click on cmdEnterRequest,
Opens frmCustomerRequests with James Smith info already populated in the name/address fields on frmCustomerRequests

So far I haven't been able to code this correctly. If anyone can help I'd appreciate it. Thank you.

 

[nhtraven]

Have you tried the DoCmd? something like this

DoCmd.OpenForm "frmCustomerRequest", , , "[FieldA] = Forms![frmCustomerData]![FieldA]", , , [FieldA]

I have only had to pass one varable to a form. I think you may have to string the fields together then separate them after they are passed to the new form

Hope this helped some