Access 97 add field

Posted on 2011-04-26
Last Modified: 2013-11-28
I have an Access 97 database split into a front end and back end.  Need to add a field to a table and form.  I have added the field to the table in the backend.
I have added the field to the form but the new field does not appear in the properties Control Source dropdown.  
I have just typed it in but when the form is opened the field contains  #Name?
How do I get the field in the ControlSource dropdown??
Question by:IBMJunkman
    LVL 84

    Accepted Solution

    Did you make sure that your Form's Recordsource includes that new field? If your form is based on a query or select statement, your new field may not be in that Recordsource, and Access won't recognize it.

    Author Closing Comment

    Also needed to know how to find recordsource but I figured that out.

    Author Comment

    Had to search around to find where recordsource was defined but I found it.  Thanks.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now