Access 97 add field

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??
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
IBMJunkmanAuthor Commented:
Also needed to know how to find recordsource but I figured that out.
IBMJunkmanAuthor Commented:
Had to search around to find where recordsource was defined but I found it.  Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.