I have a query that is calculating a client's eligibility for services. This field's output is either Yes or No depending on data from a series of other fields (automatically calculated).
On my form, I would like the "Interested" field to be active only when Eligibility is Yes. Something around these lines:
Code:
If [Eligible_PROSPollock] = "Yes" Then
Interested_PROSPollock.Enabled = True
Else
Interested_PROSPollock.Enabled = False
End If
I've tried putting this code in a few different event options, but I cannot get the field to dynamically switch from active to inactive or vice versa without manually clicking Refresh. I'd like the field to automatically activate or deactivate each time the Eligibility field changes from Yes to No or vice versa. Reminder, the Eligibility field is never changed by the user manually, it is also an automatically calculated field (iif statement from the source query).