Adding Values for DB in VB code . . .

[milkmood]

I need to append a db entry on the vb code side to add incremental numbers to the db entry. The field I'm adding to has a unique constraint.

My code looks like this:

txtCustomerNumber.Text = txtCustomerNumber.Text & " /S"

I need to append numbers, starting with 1, to the end of the /S so that the entries into the database are indeed unique.

I'm guessing I'll need to use a "For...Next" somewhere, but, believe it or not, I've never used "For...Next" (because it involves math ), so I'm not sure how to do it.