This is driving me nuts.
In Access 2010 I opened an .mdb file originally created with Access 2003. I added a field to a table, then added the field to a query. I opened a form (in design mode) which used the query as its source.
I then drug the field from the form's field list to the form.
This always worked before, but now I get the dreaded #NAME? error in the field.
I can update the field in a query data sheet view, but it won't bind to the form.