#Name? error on a form

[JonathanT]

I am trying to sum the values of 2 fields on a form The form is based on a table and no field on a form, report or table has the same name. When I add the field initially it calculates correctly. However if I close the form or database and reopen it the #Name? error appears. I can't figure out what is wrong. DB attached. Any help is appreciated

[davegri]

However if I close the form or database and reopen it the #Name? error appears.

Not much information provided to see the problem. There is no value in the form or subform that shows #Name? in the DB provided. Where do we start?

[Welshgasman]

Is it this?
=[BreakMainCalFrm]+[BreakProtCalFrm]

Why on earth is ItemMeasure so wide, which means you hav eto scroll the form?

[JonathanT]

Davegri,

The error is on the form DataEntryMeals. The Text box with the error is right under the word Breakfast

[JonathanT]

Welshgasman, That is the calulation that is throwing the error. Sorry, I do not know what you mean by ItemMeasure. I don't see any need to scroll the form. All controls on the form are easily visible.

[Welshgasman]

Well I was looking at it on a 17" laptop and the control itemmeasure was very wide for the data it held.That caused the controls to the right to not be visible unless scrolling.
That formula displayed a number for me?
If you did not upload the real db, make sure those controls are not null.
On a tablet ATM, will post pic tomorrow.

[JonathanT]

That is the real DB. The controls I am trying to sum all have a value or zero. As I mentioned before when I create the control to sum the values it works correctly. When I close the DB and open it again the #Name? error appears and does not change. Could it be some Access setting? Are the field names too long or too similar?

[CJ_London]

works for me, unable to replicate the error

[davegri]

As I mentioned before when I create the control to sum the values it works correctly.

Do you mean in design view when you create the control (add the textbox to the form) it works correctly?

The DB you submitted works fine for me. No errors. Shows proper value for all 209 records. Open form, close form, all works fine.
I deleted and re-created the text box and it also works fine. Closed DB, reopened; works fine.

I simply do not see the error you are experiencing.

[June7]

Resize columns in datasheet subform so don't have to scroll. Don't need to show ID field. What is purpose of this subform?

I also do not see #Name? error in that textbox. All records show calculated value.

[JonathanT]

I've added a screenshot of what I see when I open the form. The subform is so I know the value of an item if I want to list it in either the Snack, Dessert, Additions or Other Protein fields. I can resize the subform but does that have anything to do with my #Name? error?

[June7]

Size of form has nothing to do with that error. Error means Access cannot find referenced control.

Suggest deleting textbox and recreating.

Still weird that we do not see error.

[JonathanT]

Yes it is very weird that I'm the only one who see it. I've deleted and recreated the textbox several times sand the same error occurs after I close and reopen the database. Something else that is off is that I had several text boxes that summed values from other text boxes and they worked as designed since I created the DB in November '23. Just the other day I opened the DB and saw numerous #Name? errors. I deleted them all and have been working just to get one to work properly. The only thing that I changed was that I added a calculated field in the AllMeals table. The calculated field is not part of any sum calulation.

[davegri]

Let's try to get the result in a different way. Maybe it will shed light on why the current method fails, or if it works, go with it.
Rename the text box, and remove the control source so the textbox is unbound.
Add a form_current event to put the sum in the textbox.

Private Sub Form_Current()
    Me.BreakTotCalFrm = Me.BreakMainCalFrm + Me.BreakProtCalFrm
End Sub

[Welshgasman]

Just so you know we are telling the truth. I get a value on all the records I went back through?