Hi all
I have got a check box that when selected it copies data from another field and add a reference number after, problem I have is when I go onto another record and complete the from and go back to the previous one the REF number form the previous one appears in the text box any suggestions how to stop this?
I have got a check box that when selected it copies data from another field and add a reference number after, problem I have is when I go onto another record and complete the from and go back to the previous one the REF number form the previous one appears in the text box any suggestions how to stop this?
Code:
Private Sub CHECKBOX1_AfterUpdate()
If Me.CHECKBOX1 = -1 Then
Me.TEXTBOX2 = Me.TEXTBOX1 & "/A1)"
Else
Me.TEXTBOX2 = ""
End If
End Sub