RUNNING CLOCK

[hoonie]

HI

I'M CREATING A FORM AND I WANT IT TO AUTOMATICALLY CREATE A RUNNING CLOCK WHEN NEW NEW INFORMATION IS INTERED. PLEASE HELP. ray:

 

[Norie]

What exactly do you mean?

Do you want to add a time stamp to the new record?

 

[hoonie]

yes i would like to add a time and date stamp to a new record

 

[Tanis]

You need to add a new field to the table, e.g. fldDateAndTime as Date/Time Data type and General Date for the format. In the Before Update event of the form type in Me.fldDateAndTime = Now()

David

 

[Norie]

Add a field to your table like David says and set the default to Now().

You don't need to use an event.