Nancy Lytle
lytlenj at yahoo.com
Thu Jul 29 08:51:25 CDT 2004
Is there any way to lock only the controls in the Detail section of a form. The page header section has my filtering and navigation, and other standard buttons. All the data entry is done in the detail section. I would like to be able to open the form in two ways, one where the users can edit or add to the form data, another where they can search using the controls in the form header but they can't edit or add to the data in the detail section of the form, which also contains a subform. I have tried the following called in the Current event of the form (I also tried it in several other events and it didn't do any better): blnDisable is set in the OnClick event buttons used to open the form (from another form) for Data Entry or Open for Search only. Public blnDisable As Boolean ' in declaration section of a module Public Function fcnCheckDisable() If blnDisable = True Then Me.Section(acDetail).Locked = True Else Me.Section(acDetail).Locked = False End If End Function Any ideas appreciated, Thanks, Nancy Lytle