Results 1 to 2 of 2
  1. #1
    j2curtis64 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    56

    Form not Updating Table

    Hello,

    I want to do the following.

    I have a combo box with a field named "Approving Official". This will contain names. In the same form i have a number field (AO_CC-text box) that i want to update automatically based on the "Approving Official" value.

    I followed the instructions below.....

    The Row Source of the combo box needs to include both columns (fields). You can set the width of the Number column to 0 if you don't want it to be shown when the combo box is expanded. Then, in the Control Source of the text box put;

    =[YourComboBox].Column(1)

    It is a zero based index, so the first column (in this case the Name field) is Column(0), the second column (in this case the Number field) is Column(1), etc.


    Here is what it looks like....

    Approving Official Control Source -



    SELECT DISTINCT Contacts.ID, Contacts.LastName, Contacts.CC FROM Contacts WHERE (((Contacts.Position)="AO")) GROUP BY Contacts.ID, Contacts.LastName, Contacts.CC ORDER BY Contacts.LastName;

    Bound column = 1

    AO_CC

    =[ApprovingOfficial].[Column](2)

    This worked BUT when data is input in the form, the AO_CC field is NOT updating in the table. The other fields i am entering is updating in the table. The AO_CC field is not.

    Why is that occuring?

    Thanks

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    What is the control source for the control that is not updating to your field in the table? You may not have bound your control source to your table and a specific field.

    Alan

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

Similar Threads

  1. Replies: 3
    Last Post: 01-31-2011, 11:47 AM
  2. updating a table from a form.....
    By softspoken in forum Access
    Replies: 7
    Last Post: 04-21-2010, 09:04 AM
  3. Updating data within a form/table.....
    By softspoken in forum Forms
    Replies: 3
    Last Post: 04-15-2010, 06:33 PM
  4. Updating a table from a form
    By Lynn in forum Forms
    Replies: 3
    Last Post: 03-18-2010, 10:51 AM
  5. Updating Table field from Form
    By Kunuk in forum Access
    Replies: 0
    Last Post: 02-26-2009, 11:41 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