Results 1 to 4 of 4
  1. #1
    crsimkins is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Posts
    2

    Form Data Not updating to table

    I have been working on a form to create a transactions table for logging in and out equipment. My problem process has been automatically pulling an employees shift # to the form when that employee is selected. I used a combo box that pulled necessary data from a table called employees. I then created an unbound text box with the following control source:

    =[Checked_Out_To].[column](2)

    to populate the Shift box on the form. When the employee is selected, the correct shift number shows up in the text box. However, when I click the button to update the record, that shift information is not being copied to the Transactions table

  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,641
    This should help:

    BaldyWeb - Autofill
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    crsimkins is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Posts
    2

    Thanks for info.

    Thanks for the info. Worked like a charm.

  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,641
    No problem, and welcome to the site by the way.
    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. updating existing report with new data in table
    By newtoaccess123 in forum Reports
    Replies: 2
    Last Post: 10-18-2011, 09:50 AM
  2. Replies: 7
    Last Post: 06-10-2011, 05:40 AM
  3. Updating table data while in use
    By crispy-bacon in forum Access
    Replies: 5
    Last Post: 06-03-2011, 12:49 PM
  4. Updating Table Data Automatically
    By aquarius in forum Import/Export Data
    Replies: 6
    Last Post: 09-16-2010, 03:07 PM
  5. Updating data within a form/table.....
    By softspoken in forum Forms
    Replies: 3
    Last Post: 04-15-2010, 06:33 PM

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