Today's Date VS Original Date (1 Viewer)

[BinkyABT]

Good Evening,

I have a date field that is automatically filled in with the current date. My problem occurs when I review the record--the date changes!

I want the date to automatically appear when the record is created and to remain the same whenever the record is reviewed.

I would really appreciate any ideas.

 

[Pat Hartman]

You are probably setting the value in an event on the form. Get rid of that code and set a default value of Now() in the table instead. That will place the value in the field on an "Add" only.