I have a form called “frmDailyReport”. When I select an assignment group from the dropdown menu and run the report, I want to tag all of the records in the report as been sent. I want to accomplish this by changing the value for the checkbox in the “Site Notified” field to “Yes” in the Audit Data table. Please see the attached sample DB.
qryAuditsComplete: Query to select all records that have been audited; Uses the frmDailyReport for criteria
qrySiteGroupList: Query for dropdown list for the frmDailyReport
frmDailyReport: Input for qryAuditsComplete