If Statement

[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

 

[Jeff Boyce]

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)"