ACCESS FEED: [MS_AccessPros] How to transfer data using openargs to a form that is already open

Jumat, 15 Maret 2013

[MS_AccessPros] How to transfer data using openargs to a form that is already open

Hi,

I'm creating a data entry form where a Buyer will enter some information and then open a search form to find purchase order data based on a purchase order number the line number. If this is the right data then I want to transfer the purchase order, line, supplier and part number back to the main data entry form.

I have the DoCmd.OpenForm "frmDeviationRequest", , , , , , OpenArgs:=Me.OrderNo & "|" & Me.LineNo & "|" & Me.PartNo & "|" & Me.Supplier part working when the main data form is closed but what if you want to leave this main data entry form open while they search for the PO/Line number?

Is there another command or another way to do this?

Thank you,

Sally Vega, MBA
Supply Chain Data Analyst
Super First Class Products
B/E Aerospace, Inc.
1851 S. Pantano Rd.
Tucson, AZ 85710 USA
(520) 239-4812

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

[Non-text portions of this message have been removed]