Cindy Cheek wrote in a message to Mike Hendrix:
 CC> Hello Mike!
 MH> For the edit date create a field called say "DateLastChanged" then in
 MH> the BeforeUpdate function of the form enter this:
 CC> My field is called "Edited"
 MH>   [DateLastChanged] = Date
 CC> I entered [Edited] = Date
 CC> and nothing happened... any idea what I'm doing wrong?
Did you put this in the function Before_Update for the form?
 CC> Why would I put this in the BeforeUpdate instead of AfterUpdate or
 CC> OnChange? 
Putting it in the before_update changes the value to date just prior to the 
recorded being saved so the new value is saved in the table.  If you put it 
in the after_update it changes the value in the field on the form after the 
record is saved therefore it wasn't committed to the database just the form 
and at this point the form is either closing or moving to the next record.  
With the before update you won't see the new date on the form when you edit 
that record but the next time you edit that record it should show the last 
time it was edited.
Regards,
           Mike...
Fidonet:  1:147/114
Internet: hendrixm@msn.com
--- FMail/Win32 1.22
---------------