Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    11

    Date Validation for a course

    I've done some validation for a date [Date_attended] in a subform [course_attended] of a form [employee_2012.

    I put it in the validation part of the data in the properties section.

    It goes like this:-

    >[Forms]![Employee_2012]![Employment_Date] Or Is Null

    I thought it did work but now I get a message saying:-

    Mircrosoft Access cant find the Object ">[Forms]![Employee_2012]![Employment_Date"



    It then goes on to ask me if its a new macro or macro group and have I typed it and saved it correctly?


    What did I do wrong anyone???

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726

  3. #3
    Join Date
    Jan 2012
    Posts
    11
    The form is open but I still get the message.
    Does anyone have any thoughts?

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

Similar Threads

  1. Time and Date Validation
    By KEVWB in forum Access
    Replies: 1
    Last Post: 03-06-2011, 08:31 AM
  2. Date validation on form
    By accessnewbie in forum Access
    Replies: 6
    Last Post: 01-18-2011, 11:03 AM
  3. validation to populate date?
    By andyf80 in forum Access
    Replies: 3
    Last Post: 02-26-2010, 09:53 PM
  4. Date Related Validation
    By ldare2000 in forum Access
    Replies: 1
    Last Post: 11-12-2009, 10:49 AM
  5. Validation Rule: Date
    By krymer in forum Access
    Replies: 0
    Last Post: 08-27-2008, 03:30 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