Code new record in subform from outside of subform

[Colin Possamai]

I have 3 tables that are linked in relationship. Customers, orders, and
order details.
I have them on one form (customers) and 2 subforms (orders and order
details.)
I need the orders to be linked to customers and order details to orders.
This all works well with relationship.

My problem is I need to put up to 12 orders for one customer at one time
with a separate form and code.
I have made the form, and have all the required data I need to put into the
tables. What I can't work out, is how to add records in orders (and order
details) from outside the forms.

I have tried
DoCmd.GoToRecord , , acNewRec

but it just makes a new record on customers (main form)
I need to make a new record on subfor relating to customer relationship.

Hope this is understandable and someone can help me.

Thank you

 

[Colin Possamai]

Fixed it. Thank you

 

[MB]

I'm trying to do something similar, how did you fix it?

Thanks
Marc Berman