I have a query that identifies un-reviewed items in a table (Reviewed = False). I am pulling those items into a "Multiple Items" (continuous?) form called frm_MilitaryCheck. The form has 3 fields
1) Military Y/N (Checkbox),
2) Business Name (Text) and
3) Reviewed Y/N (Checkbox).
For all records in this form, the Military Checkbox is visible and false (unchecked), the Business Name is displayed (read only) and Reviewed Checkbox is not visible and FALSE (unchecked).
Users are told to Review the Business name, and if its Military, Click in the Checkbox. Once the records are viewed, They click a Reviewed button which closes the form. (BTW - I have an update query that runs After import and updates Exact Matches with Military = True and Reviewed = True. The records in the query based form I'm trying to update are fallout due to typos, unofficial acronyms, etc.)
So now, when the data is Loaded or Unloaded, I want the Reviewed Checkbox value set to TRUE. How do I do that? I don't use Access often enough to know more that the basics. I think I'll be highlighting the FORM and adding an "On Unload" event but I don't know what to do from there.
Here are the object names:
qry_LikeMilitary - Queries data where the Military Field is blank (false) and the Reviewed field is blank (false). Runs after exact matches are reviewed in a separate update query.
frm_MilitaryCheck - Pulls in the Military, BusinessName and MilCheck fields for all query results.
Military Checkbox - chk_Military
Business Name - txt_BusinessName
Reviewed Checkbox - chk_MilCheck (Hidden)
Using Access 2013, in Win7 64bit.
Thanks for your Step by Step response!