#Name? returned on form

[Guest]

I have created a form and when I enter the first field the 2nd field returns
"#Name?" and I am unable to enter any text. The field is contained within
the table and from what I can see the underlying table is setup correctly
(however this is obviously not the case!). Can someone point me in the
direction that I should be looking?

 

[Allen Browne]

Open the form in design view.

Right-click the problem text box, and choose Properties.

Check the Control Source property (Data tab of Properties sheet.)
Is the name in the list of fields?
Is there a list of fields to choose from? (There won't be if the form is
unbound.)

Then check the Name property (Other tab of Properties sheet.)
The Name of the text box can be the same as the field it is bound to, but it
must not be the same as the name of any other field. (Access gets confused
if the control's Name is the same as another field.)

If all that checks out okay, try disabling Name AutoCorrect. Uncheck the
boxes under:
Tools | Options | General | Name AutoCorrect

Then compact the database:
Tools | Database Utilities | Compact/Repair
Explanation of why:
http://allenbrowne.com/bug-03.html

 

[Guest]

Thanks Allen. I have done all that you suggest however still no luck. I
have checked the properties and the name is not in the list of fields. The
form is not unbound though as there is a selection available. Any
suggestions on how I get this 'new' field into the Control Source list? I
should have explained that this is a database that I'm updating so haven't
created it myself.

 

[Allen Browne]

Look at the RecordSource property of the form.

If this property contains the name of the correct table, the new field will
show up. If the RecordSource is a query or SQL statement, you need to add
the field to the query.