November 7, 200223 yr 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
November 7, 200223 yr 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.
November 7, 200223 yr Author Thanks ever so much.......works beautiful..........and something so simple.......u gotta luv this program....especially for the rookie. Cheers, ....Haps
Create an account or sign in to comment