Hi, Newbie here.
I am trying to use code to make a row/record turn bold when a check box is checked. The code goes something like this:
Private Sub Resolved_Click()
If Resolved.Value = True Then
Date_Drawn.FontBold = True
Else
Date_Drawn.FontBold = False
End If
If Resolved.Value = True Then
Slip_No.FontBold = True
Else
Slip_No.FontBold = False
End If
If Resolved.Value = True Then
Last_Name.FontBold = True
Else
Last_Name.FontBold = False
End If
...(for several more)
It works wonderfully. The problem now, is that when the first checkbox is checked, the bold applies to all of the records in the form instead of just the one it was intended for. I would like to find a way to have the code apply only to the record that includes that particular checkbox.
Thanks!