Auto change a "Yes / No" field based upon a Due Date

[hawzmolly]

Thank you June and all the other forum members. I changed the one symbol and tried the code on my sample DB. The first time it changed the "Current" field from No to Yes so I changed the ">" to "<" in the code and it worked. I added several more entries with various " DuesDue" dates. Now when I open the DB the corrections are made. Hallelujah!



The code in "OnLoad" is CurrentDb.Execute "UPDATE Members SET [Current] = Date() < DuesDue;" Don't know why it has to be < but now it changes the "Current" field from Yes to No (Checked to Unchecked).

[June7]

A 'checked' value is -1/True/Yes and 'unchecked' is 0/False/No. You want the field to be checked (meaning 'Member is Current') only if the current date is less than the DuesDue date. So you are correct to use <. I should have done some more testing of the expression.

If DuesDue date is Aug 2 2019 then Date() (Mar 5 2019) < DuesDue and should register as True in field. I hope that is representative of the results you are getting.

[hawzmolly]

All I know is it is working as I wanted. Again, thank you very much.