I have an insert statement that I have run through adodb.recordset.
now I am trying to get the primary key out of the database using Scope_identity() function .
I do not know how to call the value of it to vb.
I thought I could do selct statement
intOrderID = rs.Fields("IDENT_CURRENT").Value
but does not seem to work? any ideas?