FIELD LIST NOT UPDATING

[BBRAZEAU]

I have a form that I wish to add a control to .The control I want to add exists in a table I have.But when I pull down the field list from the tool bar it isn't there .I added the field to the table after I had created the form.Is there a way to update the form list to show this new field?(so I can drag the field from the field list to my form)If not how do I add my data from the table to my form?

 

[Chris RR]

Is the form based on the table, or is it based on a query? If the answer is "query", you'll need to add the field there first.

 

[Pat Hartman]

You can force Access to refresh the form's field collection by deleting the recordsource, saving the form and then readding it. Reports have a similar problem since they also bind the field list when the recordsource is first added. Neither automatically refreshes the list when the form/report is opened in design view.