gmmccarthy
Gary
- Local time
- , 20:14
- Joined
- Nov 28, 2005
- Messages
- 20
I have the following code on the On Current event of form PickUpReqDataFrm:
Private Sub Form_Current()
If Me.RescheduleCkBox = True Then
Me.RESCHEDULEDDATE.Enabled = True
End If
If Me.RescheduleCkBox = False Then
Me.RESCHEDULEDDATE.Enabled = False
End If
End Sub
This works fine except the action doesn't take place until I change records and then return to the one I checked.
I have tried refresh and requery but did not work.
How can I get the field to enable or disable as soon as I check the box?
Thanks for the help.
Gary
Private Sub Form_Current()
If Me.RescheduleCkBox = True Then
Me.RESCHEDULEDDATE.Enabled = True
End If
If Me.RescheduleCkBox = False Then
Me.RESCHEDULEDDATE.Enabled = False
End If
End Sub
This works fine except the action doesn't take place until I change records and then return to the one I checked.
I have tried refresh and requery but did not work.
How can I get the field to enable or disable as soon as I check the box?
Thanks for the help.
Gary
