Hi all -- new here and to Access 2007. I hope this post finds you well.
I have a database with the following 2 fields: (1) Ineligible, checkbox; and (2) Active/Inactive, dropdown menu. When a participant is deemed "Ineligible", staff clicks the checkbox AND is supposed to be checking the "Inactive" option. I find that this is redundant. I'm sure there's a way to autopopulate the text box with "Inactive" when the "Ineligible" box is checked (vice versa with active/eligible).
How can I connect these two fields to do this task automation?