Adding fields

[clauses]

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]

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]

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]

The field name does not show up on either the field list or the control source drop down list

 

[Pat Hartman]

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.