Robert,
For that very reason, you can use: PROPERTY TABLE <tablename> 'CLOSE' RETURN, redo your lookup with the new where clause and then PROPERTY TABLE <tablename> 'OPEN' RETURN without closing and reopening the form. Claudine :-) ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 22, 2008 12:03 PM To: RBASE-L Mailing List Subject: [RBASE-L] - REPLY To: Sami - Variable Lookup ComboBox - 'Custom EPP' 02-22-08 Sami, You are correct and brillant! I am changing the account number in the form with a Variable lookup and it is no longer able to find the record with the original 'Where' in Edit Using. I tested it by changing another DB edit field name using the Update command while keeping the account number unchanged! The DB edit fields did not go blank! The PROPERTY RBASE_FORM REFRESH did not work. So, I will have to issue the "Edit Using FormName" after the Update command. I thank you very much for your help today! Best Regards...Robert P. (Agemco) ----- Original Message ----- From: Sami Aaron > Ok, then try: > > PROPERTY RBASE_FORM REFRESH > > One thing to look at - when your one field is updated, is that > then changing > the value of a field that was originally referenced in the WHERE > clause that > opened the form? If so, then now that you've updated it, it > might not be > part of the WHERE clause any more so it can't re-open the same record. > > Sami ____________________________ > > Sami Aaron > Software Management Specialists > > 913-915-1971 > > [EMAIL PROTECTED] > > > Subject: [RBASE-L] - REPLY To: Jan - Variable Lookup ComboBox - > 'Custom EPP' > 02-22-08 > > Jan, > > > Thankyou for your suggestion with PROPERTY TABLE tablename 'REFRESH'. > I tried it but no solution yet! > > > ----- Original Message ----- > From: jan johansen > Date: Friday, February 22, 2008 11:00 am > > > > Try PROPERTY TABLE tablename REFRESH > > > > Jan > > > > -----Original Message----- > > When executing a Variable Lookup ComboBox - 'Custom EPP' > within > > a form, The Update command executes and then blanks out all > the DB Edit > Fields. > > >Is there a way to refresh the form after the Update without > reloading the > form again with > > 'Edit Using FormName '? > > Example of Code used: UPDATE mytable SET tablefield = > .memoryvar > > WHERE acctnumber = .memoryvar2 > > > > The Update command changes the contents of one DB Edit Field > in > > the Form based upon the selection in the LookUp List. > > > > I have tried Recalc Variables, Recalc Tables after the Update > > command > > without success! > >
