Check box to Auto fil Textbox (1 Viewer)

stu_c

Registered User.
Local time
Today, 15:50
Joined
Sep 20, 2007
Messages
489
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?

Code:
Private Sub CHECKBOX1_AfterUpdate()
If Me.CHECKBOX1 = -1 Then
Me.TEXTBOX2 = Me.TEXTBOX1 & "/A1)"
Else
Me.TEXTBOX2 = ""
 
End If
End Sub
 

Minty

AWF VIP
Local time
Today, 15:50
Joined
Jul 26, 2013
Messages
10,354
You would need to use the On Current event which fires every time you move between records.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 08:50
Joined
Oct 29, 2018
Messages
21,358
Hi. Is the textbox unbound?
 

Users who are viewing this thread

Top Bottom