Is there are control on your form named Quantity?
What is the ControlSource of that text box?
If it is a field in a talbe, what is the data type of that field (when you
open the table in design view)?
Are there any other calculated controls on a form? Once Access is unable to
resolve one of them, it gives up on the others, so they can all show #Name,
even if their expression is valid. You may need to temporarily remove the
other calculated controls to get this simple one working.
If you have not done so yet, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
This mis-feature causes no end of problems with Access being unable to find
the right names. A few of those problems are listed here:
http://allenbrowne.com/bug-03.html
Compact the database after you do that:
Tools | Database Utilities | Compact/Repair
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
Mark J Kubicki said:
if I write a statement a simple as: =[quantity]*2 it results in the error
#name? (where a control source of: [quantity] returned a correct result...
the name of the text box is neither Quantity nor UnitLoad
------------------------------------------------------------------------
Allen Browne said:
Make sure the Name of this text box is not the same the the name of one
of the field.
For example, it must not be named Quantity or UnitLoad. Access gets
confused if its Name is the same as a field, but it is bound to somehing
else.
mark kubicki said:
if I enter the control source for a text box on a subform as:
[quantity], which is a valid field, selected thru the expression
builder, I get correct results...
if I do the same for: [UnitLoad], I also get correct results
however,
=[quantity] * [UnitLoad]
yields ---> #Name?
