Make field in a form active or inactive based on the value of a calculated field (1 Viewer)

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:


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).

Try the Form_Current event

It shouldn't be necessary, but if still not updating add the line Me.Requery after your code

One other thing.
If the Eligible_PROSPollock field is Yes/No then replace the first line with

I am going to assume that this really is a text field "Yes" vs TRUE. I would write the procedure once and call it several times

call it from the forms on current and any fields afterupdate that impacts the calculated value.

Reads like you need to use the AfterUpdate event of the checkbox to do the enabling/disabling. Clicking refresh is a manual way to cause form controls to be recalculated, so you could also just Me.Refresh somewhere.

Cross posted at http://www.accessforums.net/showthread.php?t=75610

@cmray58
Please read this article about the etiquette of cross posting : https://www.excelguru.ca/content.php?184