(Q) Why do I get a #NAME error for a calculated control on a form or
(A) You are probably using the same name for a calculated text box as
one of the terms in the expression. In the following example, Access produces a #NAME
error if you enter the expression in a control named City, State, or ZIP:
=[City] & "", "" & [State] & "" ""
This creates a circular reference that may be resolved by changing the name of the
control that contains this expression to something (anything) other than City, State, or