Hello Mike!
Thursday December 12 1996 19:44, Mike Hendrix wrote to Cindy Cheek:
CC>> The first date will appear once and stay unchanged forever;
CC>> the created date.
CC>> The 2nd date will be a changing date but will change only when
CC>> that record is edited; the edited date. (hopefully
CC>> entered automatically).
MH> For the first date set the default value of the field to Date.
Ok, I can do that, and it works....thanks
MH> For the edit date create a field called say "DateLastChanged" then in
MH> the BeforeUpdate function of the form enter this:
My field is called "Edited"
MH> [DateLastChanged] = Date
I entered [Edited] = Date
and nothing happened... any idea what I'm doing wrong?
Why would I put this in the BeforeUpdate instead of AfterUpdate or OnChange?
Cindy
--- Hertzian Mail+
---------------
* Origin: Hertzian Intercept-San Diego 619-578-9247 (6pm-1pm) (1:202/731)
|