I'll do my best to describe this issue I'm having.
I have a form and on that form is a subform. The subform opens in datasheet view mode because we need to see all the records displayed AND be able to enter data in one of the fields. The main form uses tblShipments as its record source. The subform uses a query as its record source. The query used by the subform is actually a combination of 3 tables joined. Two of them are used to display information and the 3rd one is used to be able to enter a number in one of the fields.
All works fine for the 1st new record entered. But when the form is opened again , or when we click an New Shipment button, we see the original record instead of a new record. If we change the values in the one field that is unlocked on the subform all we are doing is overwriting the values from the first time. I can not make it accept new data entry.
I've attached a stripped down version of the d/b.
If someone can figure this out I'd definitely appreciate it. Just open the form frmShipment, select a customer in the main form, and make a numeric entry in the subform under Taken Qty and then attempt to make a new record.