Lock Form and all sub-forms

QB · May 26, 2009

I am using a criteria to allow changes to a form or not.

That said, I used Me.AllowEdits = True or False, but the user can still make
changes in the sub-forms?

How can I lock and unlock the form including all the subforms?

Thank you for the help,

QB

Jack Leach · May 26, 2009

try

Me.subformcontrol.Form.AllowEdits = False

In relation, Allen Browne has a nice routine for doing this, but rather than
all controls, it locks all bound controls (leaving search fields, etc,
usable).

http://www.allenbrowne.com/ser-56.html

hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)

Jack Leach · May 26, 2009

try

Me.subformcontrol.Form.AllowEdits = False

In relation, Allen Browne has a nice routine for doing this, but rather than
all controls, it locks all bound controls (leaving search fields, etc,
usable).

http://www.allenbrowne.com/ser-56.html

hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)