Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Kampala, Uganda

    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.

  2. #2
    Join Date
    Apr 2002
    You can call the Refresh method of the form, this will sync the current record with the db backend.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts