Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002

    Unanswered: What is the easiest way?

    I have a start date, end date and test completion date. I want a status box on a form to show "Active" if now () falls between the start and the end date and test completion is not filled in. Thanks.

  2. #2
    Join Date
    Jun 2004
    Make an unbound text box run an OnTimer Event:

    If IsNull([Test Compeletion]) AND Date > [Start Date] And Date < [End Date] Then
    [Name of Unbound textbox] = "Active"
    End If

    Oh and don't forget to set the timer to 1
    Last edited by dwil2g1; 06-28-04 at 12:59.

Posting Permissions

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