Can someone please provide code for the following?
I have a form named 'frm_ScheduleChanges' with about 15 fields and 5 of those fields are checkboxes. When the form opens I'm hoping to have the checkbox field named 'ALT_Pending' automatically uncheck if the date field named 'Request_Date' is more than 21 days ago and subsequently I want the field named 'CCP_Declined' to automatically become checked but only if the 'ALT_Pending' was automatically unchecked by the VBA code. And then do this for each record.
In other words: If 'Request_Date' is at least 21 days ago AND 'ALT_Pending' is checked THEN uncheck 'ALT_Pending' AND check 'CCP_Declined'
I'm not the most experienced Access user and even less experienced with VBA...so if there's something else needed just let me know.
Thanks!