I have a little checkbook / budget program I am writing.
Here is my Transactions layout:
When the user enters a Check Amt ($50), that amount is subtracted from the budget remaining (A:Remaining). This works.
But, if the user puts the cursor in the Check Amt field and presses enter again, another $50 is subtracted.
I need a way to trap the Check Amt and then compare what is entered with that amount and only IF they are different should I proceed with the A:Remaining deduction.
The script triggers ON ENTER don't seem to capture the 'pre value'.
Thanks for your ideas.