I am trying to write a transaction to another database when the user updates a record. The VBA statement is:
If Me.txtUpdate = -1 Then
The append and database information is in the query itself. I get the error:
Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'