View Single Post
 
Old October 2nd, 2006, 11:27 AM
Steve777 Steve777 is offline
Authorized User
 
Join Date: Jan 2005
Location: , , .
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Mattallyc - fantastic. That works. Thank you!

For the record, here is what I added:

strSQL = "SELECT @@IDENTITY AS NewID"
Set rsData = dcnDB.Execute(strSQL)
userID = rsData.Fields("NewID").value
rsData.Close
Set rsData = nothing