here is one technique . . .

RS.Open tableName, yourAlreadyOpenConnection, adOpenKeySet, adLockOptimistic, adCmdTable
RS.AddNew
RS("field1") = value1
RS("field2") = value2
...
RS("fieldN") = valueN
RS.Update
idOfAddedRecord = RS("nameOfAutonumberField")

Here is another. This code is executed AFTER adding your new record.

SQL = "SELECT @@IDENTITY"
Set RS = Server.CreateObject("ADODB.RecordSet")
RS.Open SQL, Connection, adOpenForwardOnly, adLockReadOnly, adCmdText

Set RS = Connection.Execute(SQL)
jobID = RS(0).Value

RS.Close
Set RS = nothing

The first technique is very much preferred as the second can be fooled in a multi-user environment. By that I mean that if 2 people are accesing you web-page at exactly the same time, one could end up displaying the others id field.

All the best

Vince

------------------
Internet Business Solutions S.L.(Spain)

What if you are using FrontPage's built in database connection? I don't think I can modify that without FrontPage saying "Contents will be overwritten when saved". Is your suggested method above, the only solution?

thanks,

Mark.

If neither of those are what you are talking about then I don't have the answer and I wish you luck either way!

All the best

Vince

------------------
Internet Business Solutions S.L.(Spain)