An Orders by Customer form has a datasheet subform with list of orders for the chosen customer.
Having clicked on one of the subform rows I launch an Orders form to see that order's details. The Activate procedure in the Orders form moves to the record for the selected OrderID using
On closing the Orders form I want to revert to the originating row in the Orders by Customer subform. At present it reverts to the top row. What will direct it properly?
Having clicked on one of the subform rows I launch an Orders form to see that order's details. The Activate procedure in the Orders form moves to the record for the selected OrderID using
Code:
DoCmd.GoToControl "OrderID"
DoCmd.FindRecord Forms![Orders by Customer]![Orders by Customer Subform].Form![OrderID]
On closing the Orders form I want to revert to the originating row in the Orders by Customer subform. At present it reverts to the top row. What will direct it properly?