Date Default Value

Z

zyus

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
 
V

Van T. Dinh

DefaultValue only applies on NEW Record, not existing Records.

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

zyus

Appreciate step by step explaination ..TQ

Van T. Dinh said:
DefaultValue only applies on NEW Record, not existing Records.

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

Van T. Dinh

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