Lock Form Macro

Question

Greetings. . After selecting a checkbox on form, I would like the form to become locked (no further changes in 'detail' of form), but would like header action buttons to be active/useable. Can this be achieved via macros or only VBA?  .. Or must the entire form become locked? Your macro info greatly appreciated if they exist. 

Have a great day!

Answer 1

Hi HawksWATN,

You can use macro to lock the fields if an option is selected. You may follow these steps:

1. Right click on the Option button then select Build Event. Select Macro.
2. You can refer on this screenshot:

As there are no lock property in the form, I suggest you use the locked property for each of the fields, to prevent modifying the values on the field once that checkbox is checked.

Let me know if you need further assistance on this.

Thanks,

Mike

Answer 2

Thanks so much Scott. I'll give it a try. Have a great day! 

MDH

Answer 3

Thank you very much  Michael, and for the follow up e-mail.  I'm good for now. Have a great day! 

MDH

Answer 4

Hi HawksWATN,

Do you need further assistance on this? Have you tried the above suggestions?

Thanks,

Mike

Answer 5

While it can be done with a macro, its very cumbersome as you have to add a macro statement for each control you want to lock. 

I use Allen Brownes' LockBoundControlsfunction which does a great job and gives you a good deal of flexibility.