I
Ivor Williams
Is there a way in a subform whose default view is either Datatsheet or
Continuous Form to change the state of a control in a single record based on
the state of another control in the same record? For example, if the subform
has the fields chkA and txtB, if chkA is true, enable txtB, if chkA is
false, disable txtB. If the following code:
Private Sub chkA_AfterUpdate()
If chkA.Value = -1 Then txtB.Enabled = True Else If chkA.Value = 0 Then
txtB.Enabled = False
End Sub
is used, regardless of which record has the focus, the state of txtB will
change in every record whenever chkA is changed.
Please let me know if I've not explained myself clearly.
Ivor
Continuous Form to change the state of a control in a single record based on
the state of another control in the same record? For example, if the subform
has the fields chkA and txtB, if chkA is true, enable txtB, if chkA is
false, disable txtB. If the following code:
Private Sub chkA_AfterUpdate()
If chkA.Value = -1 Then txtB.Enabled = True Else If chkA.Value = 0 Then
txtB.Enabled = False
End Sub
is used, regardless of which record has the focus, the state of txtB will
change in every record whenever chkA is changed.
Please let me know if I've not explained myself clearly.
Ivor