synergy46

FM 13 -- I need a 'trap'

Discussion created by synergy46 on Jul 14, 2014
Latest reply on Jul 15, 2014 by synergy46

I have a little checkbook / budget program I am writing.

 

 

relations1.png

 

Here is my Transactions layout:

Shot1.png

 

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.

 

Ron

Outcomes