Create Date and Last Open Date

[aarellano]

Hello,
I am triying to insert a create date in a form when the form is created and a open date when the form was last oppened. I have tried Date() but it changes everytime to the current date.

Any suggestions are greatly appreciated!!!!

 

[jrbarnett]

For the create date, what you need to do is to set the default value of the field to Date, but to store this in a field and use that.

For an open date, the date value is what you want - or have I misunderstood your question.

John

 

[alvechurchdata]

Do you want to record the dates when the form was created and opened or do you want the dates for each particular record? If you want the date when the form was last opened then put code in the On Open event. If you want the date for each record then put code on On Current.

Geoff Franklin

http://www.alvechurchdata.co.uk