Access 97 add field

Posted on 2011-04-26
Medium Priority
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
  • 2
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 35467634
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

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

Author Comment

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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

850 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