If Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an option box for pending, complete and delete. I would like for a
due date to be assigned to the record if the pending is clicked.

Thanks.

Jana
 
Jana

In the AfterUpdate event of that option control, you might use something
like (actual syntax may vary):

If Me.TheOptionControl = 1 Then 'use whatever # goes with "pending"
Me.YourDueDateControl = ... (whatever due date/expression you want
to assign)
Else
Me.YourDueDateControl = Null
End If

You will need to substitute the actual names of your controls.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"(e-mail address removed)"
 
Back
Top