Emoncada
02-19-2008, 09:43 AM
I have a userform with 18 txtboxes coming down in a row.
I have added vb for it
Private Sub TxtSN18_AfterUpdate()
If Left(TxtSN18.Value, 1) = "S" Then
TxtSN18.Value = Right(TxtSN18.Value, Len(TxtSN18.Value) - 1)
End If
Call CmdPS2_Click
End Sub
I am having a problem with the Call
What it is supposed to do the same action as if I clicked on the CmdPS2 button.
How can I make this work so that after data is entered in TxtSN18 it would do exactly what the CmdPS2_click would do.
I have added vb for it
Private Sub TxtSN18_AfterUpdate()
If Left(TxtSN18.Value, 1) = "S" Then
TxtSN18.Value = Right(TxtSN18.Value, Len(TxtSN18.Value) - 1)
End If
Call CmdPS2_Click
End Sub
I am having a problem with the Call
What it is supposed to do the same action as if I clicked on the CmdPS2 button.
How can I make this work so that after data is entered in TxtSN18 it would do exactly what the CmdPS2_click would do.