Results 1 to 5 of 5
  1. #1
    mll is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    3

    Writing data from textbox to table

    Newbee here

    I have a form based on one table (tblpolicy). On this form, via a textbox, I am modifying a field from tblpolicy and would like write that modified record to a new table (tbltransaction) with a command button.



    I would appreciate any suggestions that you may offer.

    mll

  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
    I'm curious what the field represents, because it would be unusual to change the same field in two tables. Other than related key fields, tables generally shouldn't contain duplicate info.

    The answer to your question is that you would either execute SQL or a query, or open a recordset on the second table.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    mll is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    3
    Paul

    Thanks for the quick response.

    The first table is a master set of records that rarely changes. The textbox on the form applies a percentage to a field from the first table. After reviewing that change I want the bookkeeper to post the change to a temporary table that will be purged monthly.

    Thanks again

    Mll

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It almost sounds like you want audit functionality, so you might search on that. In any case, let me know if you need help with either the query or recordset approach.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    mll is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    3
    Paul

    Thanks, will take a look.

    Mike

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

Similar Threads

  1. Writing Access functions
    By new2access123 in forum Programming
    Replies: 5
    Last Post: 02-06-2010, 10:47 PM
  2. Automatically Writing SQL From A Table
    By smitstev in forum Programming
    Replies: 1
    Last Post: 06-05-2009, 09:38 AM
  3. Help writing multiple queries
    By wz72n01 in forum Queries
    Replies: 1
    Last Post: 05-24-2009, 12:30 PM
  4. Combining textbox and checkbox data
    By jgarner in forum Access
    Replies: 0
    Last Post: 12-11-2008, 11:10 AM
  5. Force writing from the right in a field?
    By Looping in forum Forms
    Replies: 0
    Last Post: 01-23-2006, 03:03 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