juliesmomma
Technical User
Hi All!
What I am trying to accomplish is updating a combobox with a value that is in a text box.
The text box [Points] totals points from a survey for Cardiovascular Risk. If the number is >39 I want the combobox [Risk] automatically populated with "High". If [Points] is between 20-39 I want [Risk] to be "Medium". If [Points] is <20 then I want [Risk] to be "Low".
I have tried putting code in the change event and the afterupdate event. I've tried using a Select Case statement and a multiway IF statement. I just can't seem to get it to work.
Any help would be appreciated.
What I am trying to accomplish is updating a combobox with a value that is in a text box.
The text box [Points] totals points from a survey for Cardiovascular Risk. If the number is >39 I want the combobox [Risk] automatically populated with "High". If [Points] is between 20-39 I want [Risk] to be "Medium". If [Points] is <20 then I want [Risk] to be "Low".
I have tried putting code in the change event and the afterupdate event. I've tried using a Select Case statement and a multiway IF statement. I just can't seem to get it to work.
Any help would be appreciated.