SetValue Condition if Null

  • Thread starter Thread starter Ange Kappas
  • Start date Start date
A

Ange Kappas

Hi,
I have a field on a form which is a combo box fill called ROOMNO but
I want it to return the STATUS field if it is empty to return empty if it is
filled with a room number to return the text PENDING.

I was thinking of attaching a Macro ON EXIT where it has a SetValue command
with a condition.

What is the best way to do it ?

Thanks
 
Hi Jeff,
Yes they are two different controls there is one control
named ROOMNO and another control named STATUS.
Everytime I enter a room number in the ROOMNO Control I want it to return
the text PENDING in the STATUS Control.

Thanks
 
Ange,

If you want to do it based on your original idea, the macro would be
like this:

Condition: [ROOMNO] Is Null
Action: SetValue
Item: [STATUS]
Expression: Null
Condition: [ROOMNO] Is Not Null
Action: SetValue
Item: [STATUS]
Expression: "PENDING"
 
Back
Top