Edit two controls only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
GailK said:
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
Click to expand...


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.
 
Back
Top