Oops. In the row exit: IF vdiditrun = 1 THEN -- I said 0 before GOTO theend ENDIF
Etc ... -- Sent from my Palm Prē Emmitt Dove wrote: Karen, As others have noted, you can use the same code in the field exit and the row exit. If you don't want the code to execute on row exit if it has already executed on field exit, I suggest an approach similar to the trick for having an update trigger execute only once when the trigger needs to update the row that fired rhe trigger. In your on row entry set up a variable and give it a value, such as: SET VAR vdiditrun INTEGER = 0 Now, in the field exit: SET VAR vdiditrun = 1 Finally, in the row exit: IF vdiditrun = 0 THEN GOTO theend ENDIF .. Run the code LABEL theend CLEAR VAR vdiditrun RETURN -- Sent from my Palm Prē [email protected] wrote: Bill: I've done the same thing, putting a dummy variable edit at the end of a row. But it won't help in this situation. If they are editing a field and, without leaving that field, click on the same field in the row below it, they don't execute a "field exit" eep. They wouldn't even get to the dummy field. Karen Karen, If I need on exit field eep and it's the last editable field in the row in a region, I place a dummy variable edit field with a width of 0 to get the eep to fire. EX: set var vspoof text=.vspoof defined in the form variables. Place the variable so it gets the last tab in the row. In an on field entry eep in the dummy variable edit field I put a command to skip to the next row. Works for me. Bill Eyring
