Enable all fields and controls

[Geoff Codd]

I'm looking for a piece of code that will enable all fields and controls on my main form and subform.

Thanks in advance

 

[Rich]

Me.Form.AllowEdits=False/True etc is going to be more efficient/reliable than looping through controls.
HTH

 

[Geoff Codd]

The problem I have is that some controls are visible some are locked and others are not enabled. and I just wanted a quick way to open form and set all controls visible all unlocked and all enabled.

if you do have any ideas let me know
thanks
geoff

 

[Rich]

There have been many posts regarding this method, here's just one http://www.access-programmers.co.uk/ubb/Forum7/HTML/002844.html