Creating a field that will record the date

[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

 

[John Vinson]

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

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