Date and Time

[redeyes1965]

I want to display the current (updating real time) date and time on my form, so that when an entry is made a time stamp of when is recorded in the datbase.

Can and how?

Tim

 

[MD5150]

Set the default value property to: =Now()

 

[redeyes1965]

Thnx for this, however the field does not update automaticaly when i ammend a record.

Tim

 

[MD5150]

Using the BeforeUpdate event of your form, update your time stamp field by using:

Me.MyField = Now

This way, anytime data is entered or changed, your time stamp will be updated.

Hope this helps,

Mike Dorthick