Conditional + Manual Control Upon A Checkbox

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
F

FARAZ QURESHI

I have two fields:

Expiry Date; &
Valid (CheckBox)

Now, I need the Validity CheckBox to be unchecked if the date today is
greater than relevant record's Expiry Date everytime I open the form named
"Policy", by default.

However, upon cancellation of a policy, I need to have a manual control as
well for unchecking the Validity CheckBox manually.
 
Hi Faraz

I suggest you replace your Valid field with a field named Cancelled. This
could be either a simple yes/no field or perhaps a date field,
DateCancelled.

Then, Valid can be a calculated field in your query:

Valid: [Expiry Date]>Date() and [Cancelled]=0

or

Valid: [Expiry Date]>Date() and [DateCancelled] is Null
 
Back
Top