Results 1 to 3 of 3
  1. #1
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110

    Auto Date Problem within a Form

    Hi All

    I have a small problem with one of my forms....I have a form which a user picks a option from an drop "1" and the form puts todays date in the box, which is just what I need but........the date changes every day, so I want is to lock the date to the date the option was picked, I have enclosed the SQL below as I am sure it is somethink I have missed.

    If Me.ToDoStatus14 = 1 Then


    Me.ToDoDoneDate14 = Date

    Thanks :-)

  2. #2
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    Could this work?

    If Me.ToDoStatus14 = 1 Then
    Me.ToDoDoneDate14 = Date
    If IsNull([ToDoDoneDate14]) = False Then
    [ToDoDoneDate14].Locked = True

  3. #3
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    Nop does not work

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Auto Pop a box with a date
    By winterh in forum Forms
    Replies: 6
    Last Post: 10-02-2012, 09:52 AM
  2. Auto-populate and Attachment Problem
    By Davidyam in forum Access
    Replies: 3
    Last Post: 04-20-2012, 03:34 AM
  3. auto date
    By wthoffman in forum Reports
    Replies: 6
    Last Post: 01-17-2011, 03:35 PM
  4. form question-auto date?
    By darklite in forum Access
    Replies: 4
    Last Post: 09-02-2010, 09:32 AM
  5. Auto populating date.
    By emccalment in forum Access
    Replies: 3
    Last Post: 02-19-2010, 11:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums