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??