My Balance fields (calc fields in a related table) are not being updated after data entry. I tried commit record and refresh window scripts after entering data to get these fields to show the right balances but it didn't work. I have to close the file and reopen it to see the correct amounts.

Any idea how to fix this?

Thanks in advance.

It all depends on how you implemented your calculations. There might be a better way to do it if you describe your scenario better including the actual formulas, tables and relationships. If you have an example file, that's even better.

Hi John:

Here is the file.

Click on Deposit/Payment Tab, this takes you to a deposit layout. Click on Vendors button -> opens a new window. The user picks an invoice in the bottom window and enters its row nbr with amount to pay in the top window. The bottom window should update automatically based on what was entered in the top window. But it does not. I have to close and reopen the file to see the new balances.

Thanks

MTH.ZIP

I apologize for the long response time but I was on a short vacatiuon this weekend. I got your file but there is no data in it for me to work with and it's not clear how to enter it properly. Please send me an example with at least a few records in it. Thanks.