Need help to get rid of a #name? error

[Chris Peikert]

I created a form using the wizard and selected everything on the table to be
on the form. When I go to enter values into the form the only thing that
shows in each box is ?NAME# and it will not let me type anything in.
How do I fix this?

 

[John Vinson]

I created a form using the wizard and selected everything on the table to be
on the form. When I go to enter values into the form the only thing that
shows in each box is ?NAME# and it will not let me type anything in.
How do I fix this?

By correcting the errors on the form.

Try opening the Form in design view. View its Recordsource property.
Is that the name of the table?

Then view the Control Source properties of some of these textboxes.
Are these in fact the names of fields in your table?

How are you naming your fields? It's best NOT to include special
characters - for instance [ or ] will certainly NOT work, and
parentheses can cause problems too. Try using a naming convention such
that the fieldname starts with a letter and consists only of letters,
numbers, and (perhaps) underscores, no spaces or punctuation; I like
to use "camel case" with fielnames like CustomerID, LastName,
FirstName, and so on.

John W. Vinson[MVP]

 

[Chris Peikert]

I checked the control source and it looks correct, compare to how other form
control sources look. As for the nameing convention I used basic names such
as CompanyID, CompanyName, Address, city, state, etc...
I even tried to change the control source and point it directly to the Table
but it still gives the same error.

I created a form using the wizard and selected everything on the table to
be
on the form. When I go to enter values into the form the only thing that
shows in each box is ?NAME# and it will not let me type anything
in.
How do I fix this?

By correcting the errors on the form.

Try opening the Form in design view. View its Recordsource property.
Is that the name of the table?

Then view the Control Source properties of some of these textboxes.
Are these in fact the names of fields in your table?

How are you naming your fields? It's best NOT to include special
characters - for instance [ or ] will certainly NOT work, and
parentheses can cause problems too. Try using a naming convention such
that the fieldname starts with a letter and consists only of letters,
numbers, and (perhaps) underscores, no spaces or punctuation; I like
to use "camel case" with fielnames like CustomerID, LastName,
FirstName, and so on.

John W. Vinson[MVP]

 

[John Vinson]

I checked the control source and it looks correct, compare to how other form
control sources look. As for the nameing convention I used basic names such
as CompanyID, CompanyName, Address, city, state, etc...
I even tried to change the control source and point it directly to the Table
but it still gives the same error.

You *might* have some sort of corruption. If the form isn't too huge,
try deleting it, compacting the database, and starting over. Without
being able to look at the form (and no, please don't post it or send
it to me, I'm too busy), I can't suggest any other reason.

John W. Vinson[MVP]

 

[jahoobob via AccessMonster.com]

I like that term "camel case." It is very descriptive of what you use.

I created a form using the wizard and selected everything on the table to be
on the form. When I go to enter values into the form the only thing that
shows in each box is ?NAME# and it will not let me type anything in.
How do I fix this?

By correcting the errors on the form.

Try opening the Form in design view. View its Recordsource property.
Is that the name of the table?

Then view the Control Source properties of some of these textboxes.
Are these in fact the names of fields in your table?

How are you naming your fields? It's best NOT to include special
characters - for instance [ or ] will certainly NOT work, and
parentheses can cause problems too. Try using a naming convention such
that the fieldname starts with a letter and consists only of letters,
numbers, and (perhaps) underscores, no spaces or punctuation; I like
to use "camel case" with fielnames like CustomerID, LastName,
FirstName, and so on.

John W. Vinson[MVP]