Check an Uncheckable Checkbox on Form in Access

In today's Microsoft Access tutorial, I'm going to teach you how to check a box that is uncheckable on a form with a recordset that is not updatable. Yes, we're going to work some magic.

Olivia from Bellevue, Washington (a Platinum Member) asks: I've got a continuous form that's based on a very complex query, and because of that, the form is not updatable. However, there's a checkbox on that form that I would really like to be able to check on or off. Right now, I have to open up the customer's record, find the order, check the box, go back to the form, requery it... it's a pain. If you could show me how to check that uncheckable box, I will love you forever.

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Aggregate Query
• Not Updateable
• IIF Function
• Intro to VBA
• SQL with Access
• Requery in Place

Links

• Transparent Buttons

Recommended Courses

• Access Developer Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, check uncheckable checkbox, non-updateable form, uncheckable box, form recordset, updateable form, checkbox manipulation, checkbox functionality, checkbox hack, transparent button, sql, recordset.requery