auto date not working

[bhrosey via AccessMonster.com]

I have a form where I want the date that the information was entered to be
displayed automatically. I have the text box disabled so that no one can
change the data. In the text box I have =Date() which works fine but when I
go back to that record the next day, the date changes to that day's date.
Please help!!

 

[Douglas J. Steele]

Set the Default Value of the field in the table to =Date(), rather than the
Default Value of the control.

 

[Daryl S]

Bhrosey -

Instead, make the default value of the field in the table be =Date().

That way it will be set when the record is first created, and not changed
after that.

 

[bhrosey via AccessMonster.com]

Thank you, that should work. I knew I was missing something simple. I've
been away from Access for a few years, so I am having to re-learn a lot of
things.