• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1594
  • Last Modified:

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
1 Solution
Rey Obrero (Capricorn1)Commented:
create a query like this

Update [Audit Data]
Set [Site Notified]=-1
Where [Assignment Group]=[forms]![frmDailyReport]![SiteGroupInput]

save the query as qryUpdate  and call it in the macro after opening the report

in VBA

see the codes behind the button Run Report VBA

see attached db
kbay808Author Commented:
Thank you very much
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now