J
jamccarley
I am new to writing code and have a question. My main form has a check box,
that when checked I would like a text box to show the words "ITR Issued". The
way I have it written works, but only on the record that you are on. if you
move to the next record it stays the value of whatever you last checked. Is
there something that I need to add to tie it to each record? Here is the code
I have so far.
Public Sub ITR_Needed_AfterUpdate()
If ITR_Needed.Value = -1 Then
Text565.Value = "ITR ISSUED"
Else
Text565.ForeColor = vbRed
Text565.Value = ""
End If
End Sub
Thank you
Josh
that when checked I would like a text box to show the words "ITR Issued". The
way I have it written works, but only on the record that you are on. if you
move to the next record it stays the value of whatever you last checked. Is
there something that I need to add to tie it to each record? Here is the code
I have so far.
Public Sub ITR_Needed_AfterUpdate()
If ITR_Needed.Value = -1 Then
Text565.Value = "ITR ISSUED"
Else
Text565.ForeColor = vbRed
Text565.Value = ""
End If
End Sub
Thank you
Josh