Hello all,

I have an OSQ which has various fields and a table within it. When
accessed the OSQ is opened as
SET_FORMS FIELD '' (mode(tbl)='READ');
- At this point 'before' and 'after' field activations on the
tablefields work fine since when I move from column to column I am
displaying messages within the 'before' and 'after' activation code
which are displayed correctly.

By using an FRSKEY (from within a submenu) the OSQ is made editable by
using the command
SET_FORMS FIELD '' (mode(tbl)='UPDATE');
- At this point I need to be able to use the 'before' and 'after'
field activations but they do not work as I am able to freely move in
and out of the tablefields without any of the messages being
displayed.

Do 'before' and 'after' field activations behave differently if the
mode is set from within a submenu?
Is there a way around this? When the form is in mode=UPDATE I need to
be able to set tbl.field_3( which is a hidden tbl field) if the value
of tbl.field1 has changed or the value of tbl.field2 has changed.

Thanks,

Manny

On Jul 3, 8:47 pm, Manny <manta...@hotmail.com> wrote:
> Hello all,
>
> I have an OSQ which has various fields and a table within it. When
> accessed the OSQ is opened as
> SET_FORMS FIELD '' (mode(tbl)='READ');
> - At this point 'before' and 'after' field activations on the
> tablefields work fine since when I move from column to column I am
> displaying messages within the 'before' and 'after' activation code
> which are displayed correctly.
>
> By using an FRSKEY (from within a submenu) the OSQ is made editable by
> using the command
> SET_FORMS FIELD '' (mode(tbl)='UPDATE');
> - At this point I need to be able to use the 'before' and 'after'
> field activations but they do not work as I am able to freely move in
> and out of the tablefields without any of the messages being
> displayed.
>
> Do 'before' and 'after' field activations behave differently if the
> mode is set from within a submenu?
> Is there a way around this? When the form is in mode=UPDATE I need to
> be able to set tbl.field_3( which is a hidden tbl field) if the value
> of tbl.field1 has changed or the value of tbl.field2 has changed.
>
> Thanks,
>
> Manny

Your sub menu needs to include the field activations. That's why I
don't like sub menus as a general rule.

Thanks for that. It works as expected now.

Ta,

Manny

> > Manny
>
> Your sub menu needs to include the field activations. That's why I
> don't like sub menus as a general rule.- Hide quoted text -
>
> - Show quoted text -