invalid control property: control source (1 Viewer)

[GreenshootProgrammer]

I added a new field to one of my tables and query, but when I try to add a control for that field into my form it is not recognising it and the field isn't appearing in the sources for the form, even though the table is sourced to the form? Or am I going to have to do the usual and redo the entire form because I made a minor adjustment? -_-

 

[pr2-eugin]

Hmmm.. Okay let me see if I understand..

You selected Local Table (say sampleTable) in design view, added a new field (say sampleField) of a Type (say Text), then saved it. Closed the Table.

Next you go to the Form design view, where the Recordsource you have sampleTable and not

SELECT someField2, someField4 FROM sampleTable;

Then you click "Add Existing Fields" and you do not have the newly added field?

Did you try a Quick compact and Repair?