Circular Reference Error

[Nona]

In the database I am working on, a certain number of service units is
approved, and that number entered into the database.

A query calculates the Units Remaining by subtracting: [Units
Approved]-[Units Used]. No problem there.

The problem occurs because the number of units used must be entered each
week and added to the Units Used to update the Units Remaining figure. I
haven’t been able to do this without getting a circular reference error.

As it stands now, users must manually add the [Units Used This Week] to the
[Units Used], enter that figure and get the updated [Units Remaining]. I’d
rather they only have to enter the Units Used This Week.

I would appreciate your help!

 

[Tom Wickerath]

Hi Nona,

Circular reference errors typically result from having a field in an
expression with the same name as the control. If this is the case for you,
you can likely avoid the error by using the lowercase "txt" naming convention
for the text box involved (or for all text boxes on the form, just to be
consistent):

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763

Commonly used naming conventions
http://www.mvps.org/access/general/gen0012.htm
http://www.xoc.net/standards/default.asp

Using a Naming Convention
http://msdn2.microsoft.com/en-us/library/aa164529(office.10).aspx


You might want to try out Access MVP Allen Browne's tutorial on this subject:

Inventory Control: Quantity on Hand
http://allenbrowne.com/AppInventory.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Nona]

Thanks very much for your suggestions. I'll study these and keep trying.
--
Nona

Hi Nona,

Circular reference errors typically result from having a field in an
expression with the same name as the control. If this is the case for you,
you can likely avoid the error by using the lowercase "txt" naming convention
for the text box involved (or for all text boxes on the form, just to be
consistent):

Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763

Commonly used naming conventions
http://www.mvps.org/access/general/gen0012.htm
http://www.xoc.net/standards/default.asp

Using a Naming Convention
http://msdn2.microsoft.com/en-us/library/aa164529(office.10).aspx


You might want to try out Access MVP Allen Browne's tutorial on this subject:

Inventory Control: Quantity on Hand
http://allenbrowne.com/AppInventory.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

In the database I am working on, a certain number of service units is
approved, and that number entered into the database.

A query calculates the Units Remaining by subtracting: [Units
Approved]-[Units Used]. No problem there.

The problem occurs because the number of units used must be entered each
week and added to the Units Used to update the Units Remaining figure. I
haven’t been able to do this without getting a circular reference error.

As it stands now, users must manually add the [Units Used This Week] to the
[Units Used], enter that figure and get the updated [Units Remaining]. I’d
rather they only have to enter the Units Used This Week.

I would appreciate your help!