Is there a way to determine the next autonumber field without actually adding a record and executing .Update using ADO?

I am using a table to store successful form data copied from a temporary table and need the autonumber ID field value (for various reasons) before actually creating a record in the table.

visit
http://msdn2.microsoft.com/en-us/library/ks9f57t0(vs.80).aspx

How can you get the next value of an autoincrement field of a particular table......

Hope it will help you....

SELECT IDENT_CURRENT('TableName') + ( SELECT IDENT_INCR('TableName') ) AS NextAutoIncrementFieldValue



Email:[email protected]

Thnx

Sam