Solved using if statement on continous form

[kobiashi]

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

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?

 

[June7]

Have to use Conditional Formatting. No VBA needed.

 

[kobiashi]

Have to use Conditional Formatting. No VBA needed.

thanks for your reply, could you elaborate of give an exmple please, im not sure how it would work

 

[kobiashi]

its ok ive sorted it now, thanks for the pointer