kbay808
asked on
How to create a vba code to change checkbox value to TRUE in access for all records in a query?
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
Sample.accdb
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
Sample.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER