This should be a straightforward request, I'm just struggling with the syntax.
I have a form (frmUpd) that has functionality to write a record to another table (tblApprUpd) when a Save Record button is clicked. There is a Case Number (CASENUM) field that is a Primary Key/unique identifier. What I need is to write syntax to Append data to tblApprUpd if there is not already a record with that CASENUM in the table, or Update/overwrite the record if it does (i.e. if a previous change was added but I want to update with the latest and greatest).
i.e. a record CASENUM 1000 has field A updated so it is written to tblApprUpd. Then field B is updated and Saved, I need the most recent record with changed to both fields A and B to overwrite the record with just changes to field A.
Thank you!