I am using subforms to update Orderdetail and the MainOrder is in the parent form. Whenever I open the form, it goes to an existing order and when the new record button is pressed it goes to the new record of the child form. I would like to add a new order in the parent and pass on the control to the sub form. Could some of you assist me please.
your 'add new' record function must be under the scope of your main form.
What needs to be stored on the main form when you create new order? It seems like you wanted to pass control straight to the subform when you hit new record?