I have a database that I'm building and it is really simple except for I can't get my textbox to run my SQL command after it reaches 10 digits.
I don't have my coding with me, but it's something like this.
Private Sub RsUpdate()
Dim Rs As New ADODB. Recordset
Set Rs.ActiveConnection = CurrentProject.Conection
Docmd.runsql ( INSERT INTO ...
the update works perfectly fine if i put it onto a command button.
I tried putting this in my textbox code but it's not working. It will work after I take the focus out of the textbox.
Private Sub Text4 AfterUpdate and KeyUp
IF Len(Text4.text) = 10 Then