F
Fango
Hi,
my form has two sections of controls which contain (1) "permanent settings"
and (2) "temporary settings" for each employee. Information in (1) is always
given, where (2) overrides these settings and will be defined for just some
of the employees.
Now I need a third section which shows the EFFECTIVE settings for an employee.
That means if (2) is not empty it contains the temporary information -
otherwise it contains the settings of (1).
I implemented this by using calculated fields in the query which get the
values either from their corresponding fields in (1) or in (2).
So far so good - it worked perfect. The fields show the effective settings
for the customers without bothering if the settings are permanent or caused
by overriding temporary settings.
BUT when I'm using a filter with one of the comboboxes in the new section the
resulting datasets cannot be changed or saved anymore!! Works fine for
textfields in this section though. And for the comboboxed which are NOT based
on calculated fields. But for some reason comboboxes using calculated fields
cause problems when used for a filter.
Has anybody heard about this problem before? Can you help me? Any hints are
welcome ;-)
*Sigh*
Fango
my form has two sections of controls which contain (1) "permanent settings"
and (2) "temporary settings" for each employee. Information in (1) is always
given, where (2) overrides these settings and will be defined for just some
of the employees.
Now I need a third section which shows the EFFECTIVE settings for an employee.
That means if (2) is not empty it contains the temporary information -
otherwise it contains the settings of (1).
I implemented this by using calculated fields in the query which get the
values either from their corresponding fields in (1) or in (2).
So far so good - it worked perfect. The fields show the effective settings
for the customers without bothering if the settings are permanent or caused
by overriding temporary settings.
BUT when I'm using a filter with one of the comboboxes in the new section the
resulting datasets cannot be changed or saved anymore!! Works fine for
textfields in this section though. And for the comboboxed which are NOT based
on calculated fields. But for some reason comboboxes using calculated fields
cause problems when used for a filter.
Has anybody heard about this problem before? Can you help me? Any hints are
welcome ;-)
*Sigh*
Fango