Cindy Cheek wrote in a message to All:
CC> Hello All!
CC> Can anyone help.........?
CC> I need two dates to appear in each record of a certain form.
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 that
CC> record is edited; the edited date. (hopefully entered
CC> automatically).
CC> Does anyone know if this is possible?
CC> I've checked the "Helps" but am not real versed in this sort of
CC> thing. Any help would be appreciated.
For the first date set the default value of the field to Date.
For the edit date create a field called say "DateLastChanged" then in the
BeforeUpdate function of the form enter this:
[DateLastChanged] = Date
I believe that will work.
Regards,
Mike...
Fidonet: 1:147/114
Internet: hendrixm@msn.com
--- FMail/Win32 1.22
---------------
* Origin: -==- OKCity Ok (1:147/114)
|