Circular Reference (1 Viewer)

C

Czeszyn

Registered User.

Local time

Today, 12:44

Joined

Oct 14, 2014

Messages

128

• Aug 19, 2017

• #1

I have created a form that takes data that has been entered and put the calculation into the proper field.

I have one that says:
Total All Scrap : [HiddenTA]-[GP12]

For some reason, I am getting a "The expression cannot be saved because it contains a circular reference." Not sure why I am getting this.

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 12:44

Joined

Aug 30, 2003

Messages

36,125

• Aug 19, 2017

• #2

Are there calculations behind those? Can you attach the db here?

 

isladogs

MVP / VIP

Local time

Today, 20:44

Joined

Jan 14, 2017

Messages

18,219

• Aug 19, 2017

• #3

This suggests the value of HiddenTA is based on GP12 directly or indirectly (or vice versa).
So the calculation is a loop or circular reference