Results 1 to 3 of 3
  1. #1
    Gryphoune is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    24

    New field does not show in control source for form control

    I have table that I had to add a new field to which we update with a form. I tried to add a control for the new field but the field does not show up in the list for the control source. I am trying to add a list box to the form with a blank and 5 options.



    I have attached screen shots of the table design and the form. The table has the field in datasheet view and I have manually entered a few entries in it but it still will not show in the control source for the form control. The top section of the form is where we enter and select the data for the new records. The bottom section (circled in red) autofills the matching record, from separate tables, for updating with the new entries.

    I have added form controls for modified fields in the past so I am confused about why this is happening.

    Thanks,
    Attached Thumbnails Attached Thumbnails AuditNotesTable1.PNG   AuditNotesForm1.PNG   AuditNotesForm2.PNG  

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    That section you have circled in red on the Form looks like a Subform.
    What is the Control Source of the Subform?
    If it is a query, you will need to add that field to your query too.

  3. #3
    Gryphoune is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    24
    Thanks!!! I knew it was something minor.

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

Similar Threads

  1. Replies: 3
    Last Post: 05-03-2014, 03:26 AM
  2. Replies: 3
    Last Post: 09-02-2013, 12:58 PM
  3. My field is not found in Control Source List
    By eemiller1997 in forum Access
    Replies: 6
    Last Post: 10-25-2012, 01:49 PM
  4. Textbox Control Source As Field Input
    By Jester0001 in forum Forms
    Replies: 4
    Last Post: 03-02-2012, 10:50 AM
  5. Replies: 5
    Last Post: 10-13-2011, 03:36 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