troubleshooting Question

How can I enable/disable multiple fields with one click in Access 2010?

Avatar of Cesar Aracena
Cesar AracenaFlag for Argentina asked on
Microsoft AccessSQL
11 Comments1 Solution1581 ViewsLast Modified:
Hi guys,

I have a form that displays lots of data. Those fields are disabled by default but I want the user to be able to edit them by pressing a button. Right now I'm putting a line for each field in the "Click" event of the button (i.e. Me.FirstName.Enabled = True) but it's driving me insane.

Isn't there a fastest way to tell Access to turn all those disabled fields to enabled at once? I've searched for a method like "DisabledFields" but there's none of that. I've also tried grouping but groups don't have names so... nothing.

Thanks in advance!
Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros