Originally Posted by ga11ardo
Is there any way that this same form can also function as an order editor, where the user can select an PO and OrderID combination from a dropdown menu and have all the information about the order in both the form and the subform come up so they can edit it (ie. add products, add quantities)
Sure there is, but why would you want to add the OrderID in with this? It is an autonumber, so it would have no significance to a user. The purpose of a PO is to issue an order, so wouldn't there only be 1 PO per order ID? That's what I would think anyway.
The thing to do for something like this is to create a switchboard form (auto or manual) that pop-ups on LOAD of the application itself. Put a couple of buttons there, one for opening the form in EDIT mode, with a WHERE criteria, based an inputting PO value from the user, and the other button for opening the form in DATA ENTRY mode. Something like this would be ideal for a user, as it shows them which choices they have to go for (via the switchboard) before they even open the form.