auto number problem

[dvannoy]

I have a project that connects to a sql server via ADO.

I want the DB to auto assign a work order # to the person that enters the work order.

This is currently in Access but I am converting it to SQL server.
Below is my access code to make this happen. it works fine.
can someone help me convert this code so that it will work with VB & Sql server.

If DCount("wrkordno", "wrkord&quot = 0 Then
Me![txtWrkOrdNo] = 100
Else
Me![txtWrkOrdNo] = DMax("wrkordno", "wrkord&quot + 1
End If

Thanks alot DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[tomschafer]

If you change the datatype of the field to identity and then set the seed and increment values accordingly. i.e.

create table TableName(ColumnName int, identity(100,5))

The seed value is where to begin numbering, in the example above it would be 100, then it increments each record by 5.