#Name error in Form

[forumpall]

I've added some fields to a table in the database. When I try to use any of those fields on a form, I get a #Name? error. I've recreated the fields several times and changed the names, but continue to get the same error.

Also, if I use the new fields on a new form, they work fine.

So I created a new form and copied the fields from the old form, and the new form worked. I then deleted the old form, and saved the new form with the same name as the old form and the #name? error appears again.

I really want to use the same form name because a LOT of other queries, macros, etc. use the old form name and I want to avoid having to redo all of them.

I tried compacting and repairing the database. I've also tried unloading the form as text and reloading it. I've created a blank database and copied all the items to the the blank database. None of these things worked.

Any ideas?

 

[CJ_London]

help if we knew what names were failing (field, control, table and form) - perhaps they are reserved words or start with numbers? or the fields are lookup or multivalue fields

 

[Isskint]

Like CJ said, also do any controls on the form have the same name as one of your new fields?

 

[The_Doc_Man]

Invariably, this error occurs when Access cannot immediately locate the field that is bound to the control. The .ControlSource property of the form's control must exactly name the source field or a formula. If it is a field name then the .RecordSource for the form must exactly match something that is capable of returning a recordset (that contains that field.) This latter source can be a table or a SELECT or UNION query. If the .ControlSource is a formula then every non-constant item in the formula must name a field that is visible from the .RecordSource or must be a global function name that is visible to the Class Module of the form.

Less likely is that you have a JOIN query where some fields are identical between the two tables and you didn't correctly qualify which of the two identically-named fields you wanted in the form's textbox - so Access is confused about which field you meant.

 

[forumpall]

Controls don't have same names as fields. Fields have entirely new names.
Problem happens no matter which of the new fields I added to the table I use.
It's like the DB doesn't like those fields on this form. (The form is named Budget_Form).

Field names are DSQty, DSFrgt, STQty, STCost. all are number double fields.

 

[forumpall]

Field is coming from a select query that is pulling data from a linked table. No joins.

 

[JHB]

If you open the query direct, are there data in the new added fields?
Could you post a stripped down version of your database with some sample data, (zip it)?

 

[forumpall]

information shows up in the query.

 

[Tieval]

In the past I have found that the details are stored as the source of the query and then when you update the table fields and actual query it doesn't pass through to the form.

Look at the properties of the form and open the record source from there, you may find that it has stored the original basis of the query without updates made later.

 

[Tieval]

One other experience, if you have added textboxes to a continuous form these tend not to work, you need to correctly add the fields using Add Existing Fields from the menu.