Circular reference

Microsoft Office Access 2003

previous page next page
The Control Source property of the selected control is an expression that includes a reference to the control. Circular reference will cause the expression to fail.

You can do one or more of the following:

  • To edit the control’s Name property in the property sheet, click Edit Control Name on the Error Checking Options Trace Error menu.

    Note  If Name AutoCorrect is turned on, changing the name of the control will automatically update the control’s Control Source property. The circular reference error will still exist, so to remove the error, edit the control’s Control Source property to reverse the automatic update.

  • To edit the Control Source property of the control, click Edit the Control’s Control Source Property on the Error Checking Options menu.
  • To ignore this error and hide the Error Checking Options button, click Ignore Error on the Error Checking Options menu.
  • To turn off error checking for circular-reference errors, click Error Checking Options on the Error Checking Options menu. On the Error Checking tab, under Form/Report Design Rules, clear the Invalid control properties check box.

    Note  You can also access the Error Checking tab by clicking Options on the Tools menu, and then clicking the Error Checking tab.

    • previous page start next page