Issue with conditional imput

[Estyl]

Hi
I'm trying to set a condition in a field on a form.

I have 2 fields:
STATUS and STATUS CONDITION.


STATUS sets the status of a case > CLOSED or OPENED
When STATUS is OPEN there is the raison for why it's open in STATUS CONDITION: NEED MORE INFOS, DELIVERY SENT, ANSWER EXPECTED, (BLANK).

I would like to know how to do that the cell in the STATUS CONDITION becomes (BLANK) when the choice on STATUS is CLOSED.
Because in a CLOSED case there is no more need of raison

Thanks

[jya]

I would use a little VBA code on one of the Status events such as "On Change".

If Status.text = "Close" then
Me![Status Condition] = ""
End if

[Estyl]

Thank you very much, it's working.