Subform to main form issue

Kutrenia

New Member
Joined
Dec 31, 2009
Messages
17
I have a database with the main form titled "Orders" and a subform titled "Orders Subform". They are related through the OrderID on both forms. However, every time I add a new record to the subform it creates a new main form. I don't need 10 duplicate orders because someone ordered 10 items. This is driving me batty! If anyone has any suggestions, it would be greatly appreciated.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

rosemeyer

New Member
Joined
Apr 30, 2006
Messages
6
It sounds as if your Parent and Child relationships (when inking the forms) are backwards. How do you have your forms linked?
 

Kutrenia

New Member
Joined
Dec 31, 2009
Messages
17
Child Field: [Orders subform].OrderID
Master Field: Orders.OrderID
If I switch them around it doesn't recognize the [Orders subform].OrderID
 

Watch MrExcel Video

Forum statistics

Threads
1,122,669
Messages
5,597,470
Members
414,145
Latest member
lonnie451

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top