Setting default value

M

msgulf

I am trying to set the default value of an unbound text box using a macro.
In the AfterUpdate property in the combo box I've added this macro using
SetValue:
Item: [Forms]![frmReferrals_Main]![RefNote]
Expression: IIf([Forms]![frmReferrals_Main]![Status]="Admitted","See active
residents files for more information","See Referrals tab for more
information")
The problem is that a selection in the combo box of any record, will change
the message of my unbound box on every record to read the same thing. For
example, "Admitted" on record 1 updates correctly, but then all other records
also will display the same message, no moatter what their actual status is.
 
W

Wayne-I-M

In you macro click the view tab and select condition

Condidtion = [Forms]![frmReferrals_Main]![Status]
Then use the set value option
"See active residents files for more information"
You need to fill in the Item (the control you set the value of)
Expression = "Admitted"

Condition <> "Admitted"
Expression = "See Referrals tab for more information"
 
M

msgulf

I tried this and it's still doing the same thing.

Wayne-I-M said:
In you macro click the view tab and select condition

Condidtion = [Forms]![frmReferrals_Main]![Status]
Then use the set value option
"See active residents files for more information"
You need to fill in the Item (the control you set the value of)
Expression = "Admitted"

Condition <> "Admitted"
Expression = "See Referrals tab for more information"



--
Wayne
Manchester, England.
Enjoy whatever it is you do


msgulf said:
I am trying to set the default value of an unbound text box using a macro.
In the AfterUpdate property in the combo box I've added this macro using
SetValue:
Item: [Forms]![frmReferrals_Main]![RefNote]
Expression: IIf([Forms]![frmReferrals_Main]![Status]="Admitted","See active
residents files for more information","See Referrals tab for more
information")
The problem is that a selection in the combo box of any record, will change
the message of my unbound box on every record to read the same thing. For
example, "Admitted" on record 1 updates correctly, but then all other records
also will display the same message, no moatter what their actual status is.
Click to expand...
Click to expand...
 
Top