Locking All But 1 Field - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Locking All But 1 Field

Michel Paul

5 years ago

I have just used the technic shown in the tech help about "Microsoft Access Disallow Editing - Main Menu, Startup Form, Password, InputBox, AllowEdits, More!"

Now That I locked the form from editing the Search drop down list that I have setup to look to find different customers is also locked.

Any way to unlock the drop down list while keeping the rest of the form locked up?

	Richard Rost @Reply 5 years ago
Yes, but it's a lot more complex. You essentially would have to leave the form UNLOCKED and lock all of the individual controls that you DON'T want to be edited. In the Extended Cut of this TechHelp video I show you how to loop through all of the controls on a form in VBA. You could use that technique to lock or unlock the ones you care about: Progress Bar 2.

	Michel Paul OP @Reply 5 years ago
Thank you for the advise, Since I have 96 controls on the form it would be a lot of work. I was wondering if creating a separate form to put the Search combo box that would not be lock would allow none administrator users to use the search function to locate the correct customer out of about 170 customers in the database. Do you think it is feasible?

	Richard Rost @Reply 5 years ago
You could do that, or like the Progress Bar 2 video shows, just set the TAG property for the controls you want to lock/unlock to something like "LockMe" and then use a loop. Yeah, you have to set that property in 96 controls ONCE, but then you never have to do it again.

	Michel Paul OP @Reply 5 years ago
Thank you, I will do as you suggested.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View