Charlotte Foust
cfoust at infostatsystems.com
Tue Nov 2 16:22:11 CST 2004
Don't set allowEdits to false on frmMain, only on frmSub. On frmMain, have a routine that loops through the data controls and locks them unless you already have them locked by default in design view. The subform control gets locked along with the rest by AllowEdits. Charlotte Foust -----Original Message----- From: Christopher Hawkins [mailto:clh at christopherhawkins.com] Sent: Tuesday, November 02, 2004 2:00 PM To: accessd at databaseadvisors.com Subject: [AccessD] Locked form w/editable subform? Suppose you have frmMain and frmSub. frmMain is (duh) the main form and frmSub is the SourceObject of subform control sFrm on frmMain. How can I set frmMain.AllowEdits to False and still have frmSub behave as though it's .AllowEdit property is set to True? Right now, as soon as I change the setting for frmMain, it takes frmSub along with it. Respectfully, Christopher Hawkins Software Developer (559) 687-7591 http://www.christopherhawkins.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com