I would like to change the Background color of the label to Red when Notes is not empty in the table, this is when a combobox autopopulate the fields in the form.
The Notes textfield opens when the label is clicked on, this works, but the Background color of the label does not turn Red when there is a note.
Private Sub Form_Current()
Notes.Visible = False
If IsNull(Me.Notes.Value) = True Then
Me.notelabel.BackColor = vbWhite
Else
Me.notelabel.BackColor = vbRed
End If
End Sub
Private Sub notelabel_Click()
Notes.Visible = True
End Sub