#Name? in calculated fields

[szag via AccessMonster.com]

I have some pretty basic calc fields set up in a form. They were working just
fine. I went back into the same form and now the a #Name? error is showing up
- yet I changed nothing? Any ideas on how a clac field would work fine then
all of a sudden it doesn't work right?

 

[KARL DEWEY]

#Name? means it can not find what it thinks is a field.
Maybe you changed something that it was refering to like a field of a cross
tab query that now no longer exist.

 

[J_Goddard via AccessMonster.com]

Hi -

You may get this error if the name of a control and the name of a control
source are the same, e.g. if a control name is ProductCost and the name of
a field in the underlying table/query is also ProductCost.

If so, try changing the name of the control(s) to not match a field name.

HTH

John

 

[Mark A. Sam]

It is likely a corrupted textbox. To test it, drag a new control onto the
form with the same controlsource.

God Bless,

Mark A. Sam

 

[szag via AccessMonster.com]

Thanks!

It is likely a corrupted textbox. To test it, drag a new control onto the
form with the same controlsource.

God Bless,

Mark A. Sam

I have some pretty basic calc fields set up in a form. They were working
just

[quoted text clipped - 3 lines]

then
all of a sudden it doesn't work right?