Try declaring a variable in the form and use that to check vinvdate = INVDATE dAN gOLDBERG
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Gray, Damon Sent: Friday, March 27, 2009 12:46 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Capturing values from a form Sorry for yet another newbie question. I've just started manipulating Forms. I've found a nifty little utility in the Field Settings that allows me to call a command file or a block of code within that file on Entry or Exit from a field on the form. This is exactly what I'm wanting to do, so there is new excitement in my office!! However, I'm not yet clear on how to capture the value entered in that field so I can validate it prior to writing to the table. The field is tied to the INVDATE (Invoice Date) column in the ARTRANS table. I want to run some validations on this date prior to letting the form write to the table. I was hopeful that I could capture INVDATE as the owner of my value in the code, something like: if INVDATE is < (somevaluehere) pause 1 using "Error message here." endif R:Base is capturing the "on exit" event, but doesn't recognize INVDATE as a column or variable. How do I identify or capture the value in the field under consideration? wwwww ( @ @ ) -------oOO---(_)---OOo------- Damon J. Gray Anvil Corporation Business Services (360) 937-0770 oooo0 0oooo ( ) ( ) ----------\ (----) /----------- \__) (__/
