Tommy -
Either set a form variable to get the value in the data field (let's say, vColumnb using my original example) or use the GETPROPERTY command in the On Enter EEP to the same field. Either way, you now know if vColumnb is NULL or if it has a value. Then in the ON Entry EEP, do an IF . THEN block: SET VAR vColumnb TEXT = NULL GETPROPERTY columbID TEXTVALUE vColumnb IF vColumnb IS NULL THEN SELECT columna INTO vcolumna FROM sometable WHERE something PROPERTY columnbID TEXTVALUE .vcolumna ENDIF That way it will preserve what was already in the field. Sami From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Tommy Croker Sent: Thursday, January 24, 2008 9:35 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Scrolling Region Sami, can you elaborate on "Be sure to trap for if the field is null vs. if they tab back into it because once it's filled in you might not want the original lookup value to replace existing data." I have a similar form and if the user goes back into the field where the textvalue eep runs, it replaces the edited data with the lookup value. What is the best way to keep that from happening? Thanks _____ Date: Thu, 24 Jan 2008 07:28:59 -0800 From: [EMAIL PROTECTED] To: [email protected] Subject: [RBASE-L] - RE: Scrolling Region Sami, Thanks. Works now. Have a good day. Jan -----Original Message----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 24 Jan 2008 08:57:05 -0600 Subject: [RBASE-L] - RE: Scrolling Region Jan - Look up the value in an EEP, perhaps in the ENTRY EEP to the field in question, then use the PROPERTY command to set the TEXTVALUE of the field. The user can then change the value in the field. Be sure to trap for if the field is null vs. if they tab back into it because once it's filled in you might not want the original lookup value to replace existing data. SELECT columna INTO vcolumna FROM sometable WHERE something PROPERTY columnbID TEXTVALUE .vcolumna Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Thursday, January 24, 2008 8:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Scrolling Region Been a while since I've worked with a scrolling region. I need to have a region lookup a price (similar to SalesOrder form) but also need to be able to change it. Currently I can change it but it reverts back to the original lookup upon leaving the field I know it's simple but it is escaping me this morning. Jan _____ Climb to the top of the charts! Play the word scramble challenge with star power. Play now! <http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan>
