The information in this article applies to:
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
CAUSEThere is a circular dependency in either a form or a report. Control names take precedence over field names when binding. Microsoft Access does not provide a more descriptive error for circular references. RESOLUTION
If you need to reference the Name property in an expression, use an unbound
text box. Otherwise, reconstruct the ControlSource property expression so
that it does not reference the Name property.
STATUSThis behavior is by design. MORE INFORMATION
If you create a form based on a table or query and drag a numeric field
onto the form, by default the ControlSource property and the Name
property will be given the name of the actual field in the underlying
table or query. If you change the ControlSource property to an expression
that includes the Name property, you will see "#Error" in this field when
you switch to Form or Datasheet view. The following example demonstrates
an expression within the ControlSource property:
Additional query words: pounderror
Keywords : kberrmsg kbusage ExrOthr |
Last Reviewed: March 11, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |