Hi Claudine,
I will try your method today, so that I will not have to close and open the
same form.
Many thanks and info appreciated...Robert P.
(Agemco)
----- Original Message -----
From: Claudine Robbins
> Robert,
>
> For that very reason, you can use:
>
> PROPERTY TABLE 'CLOSE'
>
> RETURN, redo your lookup with the new where clause and then
>
> PROPERTY TABLE 'OPEN'
>
> RETURN
>
> without closing and reopening the form.
>
> Claudine :-)
>
>
> From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
> [EMAIL PROTECTED]
>
> 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
> recordwith 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.
>
> ----- 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!
