Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002

    Unanswered: update table from a form

    i have a form with a print button, save button, and cancel button. if any of the data in the form is changed obviously the save button will save the update, and the cancel button will cancel it. i need any changes to automatically be saved when the print button is clicked so as they appear in the report. note: i cannot have the form close at all though because the report is a single record report and draws off the primary key of the form. any suggestions?

  2. #2
    Join Date
    Nov 2001

    Here is what MS Access wizard generates when you create "Save button":

    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

    Just insert this code before your code to print the form.

    HTH, Igor

Posting Permissions

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