Ok, then try:
PROPERTY RBASE_FORM <FormName> 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] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 22, 2008 10:53 AM To: RBASE-L Mailing List 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! Regards... Robert P. (Agemco) ----- 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!
