Adding Values for DB in VB code . . .

[Zakary]

Why don't you keep your last entered sequence value in a Parameter table ?

(PseudoCode)

NextIdvalue = GetNextSequenceValue()
 
INSERT INTO MyTable (Id, ClientName, CustomerNumber) VALUES (txtNextId.Text, TxtCustomerName.Text,[B] CustomerNumber & " /S" & NextIdvalue [/B] ) 
 
Function GetNextSequenceValue() As String
    ' Look at param table ans return the new Sequence value + 1;
End Function

Is this suggestion is helping ??