[AccessD] Lock/Disable controls in the Detail section of a form

You can iterate through the controls in the detail using the Controls collection of the Detail section:

For Each ctl in Me.Detail.Controls
	ctl.Locked = blnLock
Next ctl

-Chris Mackin

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Thursday, July 29, 2004 8:02 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Lock/Disable controls in the Detail section of a
form


Nancy, there may be a Detail event that you could use, but I don't think so.
Have you considered renaming the controls? For instance, all the controls in
the detail section might include a prefix or suffix "dtl" or something
similar. That way you could loop through the entire form's collection and
stop only when it finds the appropriate prefix or suffix. 

Susan H. 

Is there any way to lock only the controls in the Detail section of a form.


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com