Date Default Value

[Guest]

I have field name setup_date which i want to automatically insert current
date when i open the form. The form i'm using is for EDITING the current
record.

i used the date() in the default value property in the form but cannot get
thru.(

Appreciate your response..

Zyus

 

[Van T. Dinh]

DefaultValue only applies on NEW Record, not existing Records.

Use the Form_BeforeUpdate Event to update the LastUpdateDate Field to
Date().

 

[Guest]

Appreciate step by step explaination ..TQ

DefaultValue only applies on NEW Record, not existing Records.

Use the Form_BeforeUpdate Event to update the LastUpdateDate Field to
Date().

 

[Van T. Dinh]

Check Access VB Help topic "BeforeUpdate Event". There is sample code in
the Help topic also.