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