#Name? in form fields

[Kylor]

We have a database that has been working without incident for about five years. Two people, without knowing, went in to the db to try to update the same record. Now the form is no longer working and #NAME? appears in all of the controls. What happened? What does this mean? We tried repairing it, but nothing has changed. Thanks.

 

[llkhoutx]

Is you object bound to a existing table or query?

 

[Ashfaque]

#Name? specifies that the textbox is no more connected with the datafield you set for.

Check the followings:

1. If all the textboxes on the form are giving '#Name?' while open the form then check the record source of your form. It might be changed or bymistakenly renamed or different than the existing one.

2. If record source of the form is not changed then check the source object of the form on which form is based (Table or Query) is existing or not.

Regards,
Ashfaque