Results 1 to 2 of 2
  1. #1
    meissnerb is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    6

    Code to automatically set date on form


    I need to write a code that when I select a checkbox that it automatically time stamps the date cell in the table with the date. Can someone please help me out with this. I need to do it with 20 different check mark and cell combinations.

    Thank you

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    In the after update event for the checkbox, put in this code.

    Code:
    me.yourDateFieldName.value = Date

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

Similar Threads

  1. Replies: 3
    Last Post: 04-15-2012, 09:53 AM
  2. Automatically Update Query Parameter w/ Code
    By benthamq in forum Programming
    Replies: 2
    Last Post: 08-20-2011, 03:46 PM
  3. Trying to Automatically update date within form
    By accesskid in forum Programming
    Replies: 4
    Last Post: 04-26-2011, 07:45 AM
  4. Replies: 1
    Last Post: 06-10-2010, 10:47 AM
  5. Replies: 1
    Last Post: 01-30-2010, 04:45 PM

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