Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: CancelUpdate Question

    How can I CancelUpdate when I leave a subform to scroll through another subform.

    The problem I am having is when I am working in subform1 and click the scrollbar in subform2. When this is done, the info that was being entered in subform1 is saved automatically when it loses focus. I would rather click back into subform1 and continue where I left off.

    Thanks for any help.

  2. #2
    Join Date
    Oct 2003
    Access, by design, saves the data when you leave the record. It also considers moving between forms and subforms to be a record change. This is good when you enter a header record which must exist before you can enter the sub records. You have found a case where it is bad. You could use events like GotFocus to automatically put the cursor at the end of the line, but this may not work on terminal servers:

    Me!YourFieldName.SelStart = Me!YourFieldName.SelLength

Posting Permissions

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