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:

LEARN MORE:

PREREQUISITES:

LINKS:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

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.

[shahramahmadzadeh]

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 YouTube channel and thank you for that.

[easyspeak]

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

[bharatkhatri]

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.

[JohnSchmidBAP]

glad I found your spot on YouTube. This trick is exactly what I was looking for. I have to conditions that need to be met before locking a form or record. Is "and if" allowed in a Vba expression. so when both of 2 conditions are met the form locks, but not if only one or the other is met?

[bolentie]

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

[gregoryjeffries]

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