Edit two controls only

[GailK]

Good morning,

Problem : have an "EDIT" button which is for editting two option groups only
but when clicked on all controls can be editted. The requirement for me is
to not allow any editing except within the two Coaching areas .. once the
coaching has taken place the data must be updated.

Thank you for your assistance.

Access 2000
Form data properties : Allow Edits = No
Allow deletions = No
Allow additions = Yes
Data Entry = No
*All controls : Locked = No ...... except for the two option boxes which are
Yes
Option Box : Recommended
Yes = defaulted (-1)
No
Option Box : Actioned
Yes
No = defaulted (0)

Existing coding on EDIT button:

Private Sub cmdEdit_Click()
Me.Recommended.Locked = False
Me.Actioned.Locked = False
Me.AllowEdits = True
End Sub

 

[Marshall Barton]

Problem : have an "EDIT" button which is for editting two option groups only
but when clicked on all controls can be editted. The requirement for me is
to not allow any editing except within the two Coaching areas .. once the
coaching has taken place the data must be updated.

Thank you for your assistance.

Access 2000
Form data properties : Allow Edits = No
Allow deletions = No
Allow additions = Yes
Data Entry = No
*All controls : Locked = No ...... except for the two option boxes which are
Yes
Option Box : Recommended
Yes = defaulted (-1)
No
Option Box : Actioned
Yes
No = defaulted (0)

Existing coding on EDIT button:

Private Sub cmdEdit_Click()
Me.Recommended.Locked = False
Me.Actioned.Locked = False
Me.AllowEdits = True
End Sub

The AllowEdits property applies to the entire form so you
can not use it as a kind of default for some of the
controls.

Leave the Allow Edits set to Yes and set all controls Locked
property to Yes. Then you can just manipulate the
Recommended and Actioned controls Locked property as needed.