• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Today's Date VS Original Date (1 Viewer)



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, 06:55
Feb 19, 2002
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