Today's Date VS Original Date (1 Viewer)

B

BinkyABT

Guest
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

Super Moderator
Staff member
Local time
Today, 11:31
Joined
Feb 19, 2002
Messages
42,987
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.
 

Users who are viewing this thread

Top Bottom