I've put together a grid (thanks to the help from UTers!!!) so my users can enter data quickly via a spreadsheet method. Overall, it works quite well.

Here's the problem: I've got a column for debits and another for credits. I'd like to have a text field on the form that will give the users a running net total so they can be sure their entered transactions add up to 0 (zero), as all good double-entry GL transactions do.

I've tried using each debit/credit cell's GOTFOCUS method to store the existing cell entry in a OrigDebit and OrigCredit property. Then, in that cell's VALID method, I look to see if the amount changed by comparing THIS.OrigCredit (or OrigDebit) to THIS.VALUE. If it has, the net change would be applied to the displayed NET TOTAL field on the form, and updated.

Apparently, the GOTFOCUS method is not the right one, because the THISFORM.OrigCredit (or THISFORM.OrigDebit) value is not getting updated upon entry to that cell.

Any suggestions, please? Thanks!
- Gerry