Creating a field that will record the date

  • Thread starter Thread starter skullymatjas
  • Start date Start date
S

skullymatjas

how can i create a field that will record the date that i
inputed information into a different field. the general
records are all ready there, i am just puting info into a
new field

thankx
 
how can i create a field that will record the date that i
inputed information into a different field. the general
records are all ready there, i am just puting info into a
new field

thankx
Click to expand...

In order to record the date that an existing record was modified, you
must - no option, tables don't have any usable events! - ensure that
all editing of the data is done using a Form.

Put a Date/Time field (DateModified let's say) into the table; in the
Form's BeforeUpdate event put code like

Private Sub Form_BeforeUpdate(Cancel as Integer)
<any form validation code goes here>
Me!DateModified = Date ' use Now if you want date and time
End Sub
 
Back
Top