Rules seem to apply randomly...

[Fred Boer]

I have a repeating table which contains a number of textboxes, some of them
populated with the results of calculations. I have a rule defined to update
the value of (say) field2 when field1 has a particular value.

Unfortunately this rule seems to be applied in a totally random manner...

Notes:

field1 is populated automatically using a calculated value. Is this an
issue?
Is there an order or sequence in calculations involving several fields, for
example one field's value is used in a calculation in another field's value,
which is then used (via rules) to set the value of a third field?

Thanks!
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/

[Fred Boer]

Hi all:

I've solved this one on my own... or if not solved, then at least found a
workaround:

One field's (field1) value is used via rules to set the value in another
field (field2).
Field2 has a default value.
I only wanted to set the value of field2 for two specific values of field1,
otherwise field2 should remain the default value.
Didn't work. Random values were being inserted in field2.

Workaround:

Explicity assign value to field2 for all possible values of field1 (i.e. you
can' t rely on default value)

Cheers!

--

--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/

"Fred Boer" <fred...@NOyahooSPAM.com> wrote in message
news:OhfRgqIb...@TK2MSFTNGP04.phx.gbl...