SetValue Condition if Null

[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

 

[Jeff Boyce]

Ange

I'm not clear what you are trying to do...

It sounds like you want a combobox (?named RoomNo) to show a status.
Wouldn't these be two different controls on your form?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Ange Kappas]

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

 

[Jeff Boyce]

In the AfterUpdate event of the ROOMNO control, add something like
(untested):

Me!STATUS = "PENDING"

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Steve Schapel]

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"