update records in a subform from form edit

[mdrogan]

I have two forms in question. Invoices and Invoice Details subform. The records are stored in another table called Inventory Transactions. Default value of InvTransDate = Invoice date on the main form. My problem is that when I change the date on the main form, only the first record on the subform reflects the change. I need all of the records in the subform to be updated at the same time.

Thanks

 

[Jack Cowley]

Create an update query to update your records.

 

[Pat Hartman]

The invoice date should ONLY be stored in the Invoices table. It does NOT need to be duplicated in the InvoiceDetails table. An Invoice can only have one date. That should be the clue that tells you where the data should be stored.