Results 1 to 2 of 2
  1. #1
    Jaik is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Aug 2016
    Posts
    33

    IS possible to capture form's data and store it into the another table?

    I am trying to capture form's data and store it into history table.



    My form contains columns from 4 tables and I am doing the summing, multiplication and subtracting calculations with data. Form columns data types are text, calculated fields, and a memo column.
    So This form does not need any action for users to see the result. Is possible to store form data result into a history table? Or is possible to make a button to save data into the history table?

    Thank you

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Normally you'd create an audit trail, plenty of examples around if you search on that. If you need to do what you describe, it wouldn't be hard to use the AddNew method of a recordset or an append query to take values from the form and append them to a table.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Capture a form's Open instance to a table
    By DubCap01 in forum Forms
    Replies: 7
    Last Post: 04-01-2015, 01:26 AM
  2. Proper form design and data capture
    By hect1c in forum Forms
    Replies: 1
    Last Post: 11-20-2014, 02:35 AM
  3. Replies: 2
    Last Post: 12-02-2012, 09:14 PM
  4. Replies: 1
    Last Post: 05-23-2012, 12:46 PM
  5. Capture Form Data to Export to Excel
    By ajones92 in forum Forms
    Replies: 8
    Last Post: 06-16-2011, 03:35 PM

Tags for this Thread

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