Code new record in subform from outside of subform

  • Thread starter Thread starter Colin Possamai
  • Start date Start date
C

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
 
I'm trying to do something similar, how did you fix it?

Thanks
Marc Berman
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Launching a Form from Within a Form to Create a New Record 1
How do I tab from subform to subform? 1
how to create new record automatically 2
Can't Enter New Record in Subform 4
Reports for individual records 1
Updating subform on Tab Control page 0
Move Form to a new record 4
Subforms 10

Back
Top