I have a form which shows records in a table. But the table can have more than one record that has the same InvoiceN. InvoiceN is a text field.
When the user has entered data into the following fields on the form that is displaying the first record of records with the same InvoiceN, I want all the records with that same InvoiceN to have the fields updated to match the first record.
The fields are:
Should the code be in the afterupdate event of the form or the beforeupdate event of the form? Somehow it has to be done before the user navigates to another record. And what should the code look like?