Date Field

[moleary]

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???

 

[Jack Cowley]

Put 'Date()' (sans quotes) in the Default Value of the field. Then the date will only be entered when you enter a new record.

 

[jwindon]

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

 

[moleary]

thanks alot!! both helped!~