I'm getting a Script failed error. I think this is because the Field name is on page 1 and the field with the calculation is on page 2.

[Christy_Scott]

I'm getting a Script failed error. I think this is because the Field name is on page 1 and the field with the calculation is on page 2.

The formula is just +Cash.  I don't know how to tell it to look on Page 1.  If I use the same field on Page 1, the formula works so I know it is not something in the field name.

This has NOT been answered

[jasotastic81 · Accepted solution]

Page1.Cash should do it. If it doesn't, you could use CTRL+click to enter the name into your script.

1. Select the field you're adding the script to.
2. Scroll the Design view until you can see the object whose name you need. (Not be needed if object is already in view)
3. Click inside the script window to place the cursor where you want the name of the other object.
4. Hold down the CTRL key while left-clicking the object whose name you need.