Lock a check box if another check box isn't ticked

philtr

Registered User.
Local time
Today, 09:17
Joined
Mar 19, 2008
Messages
11
Very new to MS Access so go easy ;)

I've got two check boxes, one called Completed and the other called Infill, i'd like the Infill box to be locked or unabled unless the Completed box is ticked. Any method of doing this?
 
In the Properties sheet set InFill.Locked to Yes.

Then, in code:

Code:
Private Sub Completed_AfterUpdate()
  If Completed Then
    InFill.Locked = False
  Else
    InFill.Locked = True
  End If
End Sub
Code:
Private Sub Form_Current()
 If Completed Then
    InFill.Locked = False
  Else
    InFill.Locked = True
  End If
End Sub
 

Users who are viewing this thread

Back
Top Bottom