I currently have a database that also copies some data to a sharepoint list for use by other agencies within my organization.
This is done upon updating a form which obviously saves the data to my table, then I have to manually hit buttons with macros that will - save record - run an updatequery to make changes to the identical record in the mirrored Sharepoint list - or run an append query to write a new record in the sharepoint..
I would like to make this a single button, OR even better, tie it to an AfterUpdate. My question is how would I code the macro to run the updateQuery IF record exists, and if it doesnt, then run the append? Is there an easier way? I think the UpdateQuery would obviously fail if the record doesnt exsist, so would that stop a single macro, or is there an IfError I can do in the middle of a Macro?