I am building a simple (or so I thought) data entry form based upon an orders table with a details subform. In the main form I have the fields orderID, Date Ordered, and VendorID. OrderID is the primary key and the vendor Id is a combobox looking up a list of vendors in another table. The subform shows the detail records for items the user wants to add to the order. The subform is tied to the order details table which is a junction table between orders and properties. Some of our teams order multiple items for one property, others order the same item for multiple properties. The junction table has a multiple field primary key made up of the orderID, property number, and item number. My plan is to build independent data entry forms for each team. The one I am building now will be for orders of multiple items against one property. The problem I have is that when I enter a record in the main table the orderID field does not get populated for the subform records. The error for missing primary key is thrown, and after I hit ok four or five times, it lets me continue with entering data in the subform but still does not populate the orderID. If I click through the error messages, enter data in the subform, then hit escape, the orderID is passed to the subform and I can continue entering data and save the record. I can't figure out why the orderID is not being passed to the subform at the beginning of the data entry.