How to Lock the Parent Form & Subform Based on a Condition in Microsoft Access (Lock Order if Paid)

In this Microsoft Access tutorial, I will show you how to lock both a parent form and its subform based on a payment condition. Discover the steps to prevent edits, deletions, and additions to an order once marked as paid, ensuring data integrity in your database application.
Gary from Warwick, Rhode Island (a Platinum Member) asks: I followed the techniques you showed in your Disallow Editing Data video to lock orders once they are marked paid. However, this doesn't prevent the user from modifying the records in the order detail subform. How can I lock the whole thing down?
BECOME A MEMBER:
RUclips: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
Lock Subform: 599cd.com/Lock...
PREREQUISITES:
Intro to VBA: 599cd.com/Intr...
If Then: 599cd.com/IfThen
Disallow Editing Data: 599cd.com/Allo...
After Update: 599cd.com/Afte...
On Current: 599cd.com/OnCu...
Invoicing: 599cd.com/Invo...
LINKS:
Edit Mode: 599cd.com/Edit...
Prevent Deletion: 599cd.com/Prev...
Simple Security: 599cd.com/Simp...
RECOMMENDED COURSES:
Access Security Seminar: 599cd.com/Secu...
Access Developer 9: 599cd.com/ACD9
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database,, lock parent form, subform condition, Access form locking, prevent record modification, VBA lock form, disable form editing, conditional form control, paid order lock, VBA After Update, VBA On Current, Access subform locking, restrict Access subform, lock Access form fields
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[@shahramahmadzadeh5285]

Thank you sir, really thank you very much, every time you produce a new educational clip I learn a lot, but instead I can only come to your RUclips channel and thank you for that.

[@easyspeak101]

The MSAccess Team have put some tricky bits to navigate.. So thank you very much Richard for all the patch and repair advice .. 👏👍🍪

[@bharatkhatri1987]

Love it.
Will help me lock a lot of forms after certain actions in Invoice, bill of ladings, receipts etc etc, in my software.
Thanks.

[@Shadow.Dragon]

Thanks for the great video, Richard!

[@599CD]

My pleasure!

[@alializadeh8195]

Thanks

[@rincondeolocuilta]

thanks!

[@bolentie]

Could you please suggest how to organize employees scaned documents to be stored and opened via access db form of employees? Thanks

[@gregoryjeffries8475]

The subform can still act as a stand alone form which explains why you need these extra steps.