I have designed a form for my database and I am trying to create a macro that will enable a control if the value of the first two controls is greater than zero. The controls I am working with are three option groups. Each option in those groups are set to a value.
Control Names: Question1, Question2, Question3
Condition: (([Forms]![sbFrmQuestionnaire]![Question1]-1)+([Forms]![sbFrmQuestionnaire]![Question2]-1))>0
Action: SetProperty
Arguments: [Question3], Enabled, -1
I applied it to the OnCurrent property of the form. However, when I set the values that will satisfy the condition, the control does not function correctly (i.e., the control is not enabled). What is wrong with my code?