Unanswered: Updating the current record without moving to another record
I've got a form with an export button. When I press the exporet button some of the data is read by SQL queries and written to an output file. If some of the dat has changed on the form th eold values are output, not the new values - the record is only updated whenever the current record changes.
Is there a command to force the form to write its changes back to the database when I press the export button?
I tried using the Update statement but I get the error;
Update or CancelUpdate without AddNew or Edit.