Results 1 to 3 of 3
  1. #1
    goodguy is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Dec 2010
    Location
    Zanzibar, Tanzania
    Posts
    228

    Manually SAVE a record on a bound form

    I have a bound form for users to add records to a table.
    When a record is saved, the user may opt to view results of several calculations based on the saved record and may want to print the calculated data to another table and/or print it out.
    I have set a command button on the form which I want to enable once the user has finished entering data, i.e. when the record is saved.


    In bound forms, the record is normally saved when the user navigates away from the record, but I want to enable the command button immediately after saving and BEFORE the user navigates away from the page.
    The logical approach would be to intercept the form's AFTERUPDATE event. Or to provide the user an option to manually SAVE the record, although it is on a bound form. Can we use code to save a record on a bound form?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Of course! If Me.Dirty Then Me.Dirty = False

  3. #3
    goodguy is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Dec 2010
    Location
    Zanzibar, Tanzania
    Posts
    228
    Thanks. Will try and revert.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. On Add record, how do I force a Save first?
    By KathyL in forum Programming
    Replies: 11
    Last Post: 07-18-2011, 12:37 PM
  2. Replies: 1
    Last Post: 04-19-2011, 04:46 PM
  3. Replies: 9
    Last Post: 01-20-2011, 02:22 PM
  4. Duplicate Record Cannot Save
    By magicscreen in forum Programming
    Replies: 2
    Last Post: 09-15-2010, 08:15 AM
  5. save last record in table through a form
    By ajetrumpet in forum Forms
    Replies: 3
    Last Post: 09-09-2010, 08:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums