Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    11

    Unanswered: Yes/No field - Date Field

    I have a Yes/No field that correspondes with a date field. Is there a way to automatically get a check in the Yes/No field if there is a date in my date field ??? If so how do i go about doing this


    Thanks in advance.

  2. #2
    Join Date
    Nov 2003
    Location
    Europe
    Posts
    369
    - in the after update event on your date field, place this code:

    Sub Yourdatetextboxname_AfterUpdate()
    if not isnull(me.YourdatetextboxnameGoesHere) then
    me.YourYesNoControlNameGoesHere = Yes
    end if
    end sub

    Daniel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •