automatic input and revision dates

[AndyTilia]

Hello-- I'm trying to find a way to use the date() function and OnClose-like events to automatically fill a field for "original input date" and "last revision date" (the first date 'sticks' when record is created, the second is revised with current date every time the record is updated).

Thanks for any suggestions!

Andy

 

[gol4]

Use the afterinsert event and afterupdate event on the form to accomplish this instead

Private Sub Form_AfterInsert()
[Dateinput] = Date
End Sub