how to make a field mandatory

[agtjazz]

How do I make a field mandatory based on the contents of another field?

For instance, if the status is Approved, the Approval Date should become mandatory. If the status is Denied, the Denial Date becomes mandatory.

In the Approval Date, I could go under validation and enter the calculation

If (status = “Approved”; not isempty(dateapproved))

But it doesn’t make it mandatory

What am I missing?

Thanks in advance

[bcooney]

This doesn't directly answer your question, but why not set the Approval Date when the user clicks the Approved checkbox?

[agtjazz]

That would work too, but if my field (status) is a drop down list, how do I do that?

Thanks

[weststreet]

You could make the Date field a calculation, and use a Case argument for each of your status options.

Case(

Status="Approved"; Get(CurrentDate);

Status="Denied"; Get(CurrentDate); "")

Changing different results to match your status, though.

Edited September 12, 2007 by Guest