i have two fields on a continous form, reason im using a continous form is so i can use a delete entry button.
CbxEventTracker and CbxNonEventTracker
when the CbxEventTracker has an entry, i want to grey out the CbxNonEventtracker field
this is what i used
It does work, but the problem is it locks all the other rows out aswell, so how do i make it only effect one row at a time?
CbxEventTracker and CbxNonEventTracker
when the CbxEventTracker has an entry, i want to grey out the CbxNonEventtracker field
this is what i used
Code:
Private Sub CbxEventTracker_AfterUpdate()
If Not IsEmpty(Me!CbxEventTracker.Value) Then
Me!CbxNonEventTracker = "20"
Me!CbxNonEventTracker.BackColor = RGB(156, 156, 156)
Me!CbxNonEventTracker.Locked = True
End If
End Sub
It does work, but the problem is it locks all the other rows out aswell, so how do i make it only effect one row at a time?