Results 1 to 5 of 5
  1. #1
    olycoug2001 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2016
    Posts
    2

    Form Field Error

    Good Afternoon. Im trying to add a field to my form. However, when I go to add it, it isnt my fields list. Ive added the field to my table so Im not sure why it isnt showing in my fields list. Im sure Im missing an easy step, just dont know what it is.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Change the Record Source table and save. Then open the form in design view again and set the Record Source back to the table again and save.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    If that doesn't work, the Form may actually be based on a Query...and while the Field has been added to the Table, it hasn't been added to the Query, hence it isn't in the list.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    olycoug2001 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2016
    Posts
    2
    Thank You. Between those two ideas I was able to get it solved

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I marked this thread as *Solved* for you using the *Thread Tools* at the top of the thread.
    https://www.accessforums.net/showthread.php?t=1828

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

Similar Threads

  1. Error on updating field in form
    By donsi in forum Forms
    Replies: 1
    Last Post: 09-22-2016, 09:46 AM
  2. Replies: 10
    Last Post: 04-27-2016, 10:24 AM
  3. Replies: 7
    Last Post: 01-04-2016, 01:10 PM
  4. Filter email field on continuous form gives error
    By Ruegen in forum Programming
    Replies: 7
    Last Post: 10-10-2013, 09:31 PM
  5. #Type! Error for Number Field in Form
    By CementCarver in forum Forms
    Replies: 4
    Last Post: 06-06-2013, 04:45 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