Date Stamp Only When *Field* Changes, not Whenever *Record* Change

[newt]

Can anyone tell me how to stamp the time that a particular *field* of a
record changes? For example, if one or more of the other fields of the
record change, but not this particular field, I don't want the time stamped.
I see tons of discussion of how to date stamp when a record changes, but not
just when a particular field changes.

Thanks very much!

 

[Albert D. Kallal]

Can anyone tell me how to stamp the time that a particular *field* of a
record changes? For example, if one or more of the other fields of the
record change, but not this particular field, I don't want the time
stamped.
I see tons of discussion of how to date stamp when a record changes, but
not
just when a particular field changes.

Thanks very much!

Just use the fields after update event.....go:

me.MyTimeFile = now()


Note that "now()" sets both the date + time value....

 

[Allen Browne]

Use the AfterUpdate event procedure of the text box on your form to assign
the date to the date/time field that records this.

That will work provided the field is not modified programmatically, or
outside the form.

If you don't want the update recorded if the user changes it back to the
OldValue, use Form_BeforeUpdate to undo the date/time if the Value and
OldValue of the text box are the same.

 

[Tony Toews [MVP]]

Can anyone tell me how to stamp the time that a particular *field* of a
record changes? For example, if one or more of the other fields of the
record change, but not this particular field, I don't want the time stamped.
I see tons of discussion of how to date stamp when a record changes, but not
just when a particular field changes.

Some concept as the record change time stamp but this would most
likely be in the field on the forms After Update event. (You could
be it in the forms BeforeUpdate event but that could be a little more
work.)

Tony

 

[newt]

Thanks to all of you for your responses - much appreciated!