field modifying flags

[Haps93]

not sure if this is the correct forum, but here goes.......I'm attempting to have a flag field switched "on" whenever a specfic field has been modified so that users can easily see which fields have been modified. I only want to flag actual changes. Any suggestions will be greatly appreciated.

...haps

[BobWeaver]

Make the flag field an auto-enter using this calculation:

Case(FieldToBeMonitored,"Modified","Modified")

You will have to clear the flag field intitially after you define this calculation, but afterwards, any change to the target field will cause the Flag field to show "Modified". You can then reset it by clearing the field.

[Haps93]

Thanks ever so much.......works beautiful..........and something so simple.......u gotta luv this program....especially for the rookie.

Cheers,

....Haps

[BobWeaver]

Just wait. It gets worse.