New Field Will Not Show Up in Form

[batowl]

I have a database that was nearing the end of construction. I am finishing the form when I realized I forgot to include a field in one of the tables. I went back to add the field to the table, no problem. But when I try to add that field to the new form, it does not show up as an available option in the Control Source list.
What am I doing wrong?


I have been able to edit fields in the table then update their corresponding field in the form, but this new field in the table will not show up in the form. Any suggestions?

[RuralGuy]

Are you using a query as the RecordSource of the form? Is so then change the RecordSource to the table, save it and then set it back to the Query. This will refresh the RecordSource.

[batowl]

Well, I don't see RecordSource as an option in the combo box's property list, only ControlSource. And nope, no queries are involved. Only a bunch of tables (in one to one relationships) and one form. For whatever reason newly added fields to table just are not showing up as an option under ControlSource.

[RuralGuy]

It is the RecordSource of the FORM to which I was referring.

[batowl]

hmm never fooled with that before. Where would I find that?

[RuralGuy]

First you need to select the FORM by clicking the box in the upper left of the form in design mode. Then the RecordSource is on the Data tab of the property sheet.

[batowl]

Wow, never seen this before. Thanks!

So the RecordSource looks like the correct table. When I look at the query builder, the field I want to add to the form is part of the list inside this correct table, but not down below (where it would actually be part of this query). So I guess I can add it to this lower section and it will now show up?

[batowl]

That did it. Awesome! Thanks so much!

[RuralGuy]

Excellent! Thanks for posting back with your success.

[RuralGuy]

So that others that read this thread understand, Access creates it's own "query" for the RecordSource of the form. You don't see it, but its there! Removing the RecordSource and saving and then setting the RecordSource back to what it was forces "Access" to re-create the hidden query that now contains all of the latest table specifications.