clauses
07-11-2001, 07:55 AM
I have a form that is associated with a table in my database. I have added a field to the table and am not really sure how to add the field to my form, the new field does not show up in my field list. Is there a way other then recreating the form from scratch to add the field to the form.
Jack Cowley
07-11-2001, 09:21 AM
I have not seen this problem before. Try adding a text box and then select the Control Source property and click the down arrow in that field to see if your new field happens to appear there. If not it sounds like you may have to redo the form as they do get corrupt on occasion.
charityg
07-11-2001, 09:39 AM
Also, if somehow your form is linked to a query rather than a table, you need to make sure you add the field to underlying query before it will show up in the field list.
~Charity
clauses
07-13-2001, 06:19 AM
The field name does not show up on either the field list or the control source drop down list
Pat Hartman
07-13-2001, 06:33 AM
If you are sure that the field has been added to the query, you can force Access to re-read the querydef by doing the following:
1. Delete the query name from the report's recordsource.
2. Save the report
3. Paste the query name back into the report's recordsource
4. Save the report
The report should now "see" the new columns.