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

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



More information about the AccessD mailing list