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 Ofjan 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
