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
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    yes put an afterupdate() function on the date field....

    Code:
    Private Sub Yourdatefield_AfterUpdate()
    youryesnofieldname.value = -1
    '-1 = yes on check boxes
    End Sub
    Hope that helps,
    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

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