Date Field

moleary

Senior Member
Local time
Today, 23:41
Joined
Feb 9, 2001
Messages
58
I have a date field in a form that puts in the current date, but when you re open the form at another time it puts that date in, how do I keep it from changing the date, I want the original date that it was first created to stay in there? is this possilbe???
 
Put 'Date()' (sans quotes) in the Default Value of the field. Then the date will only be entered when you enter a new record.
 
moleary:

Are you storing the date in your table? It sounds like your field is unbound in which case, it WILL change every day or time.

If you are wanting to save the date of a record being entered. Set the default value of your field to now() in table design view. You can add code on your form on the Form's AfterUpdate event to set the value of the RecordEntered date field to a new NOW().

HTH
 

Users who are viewing this thread

Back
Top Bottom