Sally
If you want to leave the main form open you can just open the second form in Dialog mode. That will bring it to the top and suspend and code running on the main form until the second form is closed.
Docmd.OpenForm FormName:="frmDeviationRequest", _
WindowMode:=acDialog, _
OpenArgs:="your stuff"
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, Sally Vega <sally_vega@...> wrote:
>
> 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]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar