Setting default value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"
 
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...
 
Back
Top