Date Default Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
DefaultValue only applies on NEW Record, not existing Records.

Use the Form_BeforeUpdate Event to update the LastUpdateDate Field to
Date().
 
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...
 
Check Access VB Help topic "BeforeUpdate Event". There is sample code in
the Help topic also.
 
Back
Top