SQL stmt to get most recent data from a table

[merlynsdad]

I'm using VBA and SQL to input data from a form into a table using autonumber as the primary. I then need to retrieve the autonumber of the row just entered into another form. I'm getting a number, but it's the number of the beginning row in the table, not the one just entered. What's the SQL statement to retrieve the most recent row? And should I put the code in the form load event, or is there a better place?

If the square peg won't fit in the round hole, sand off the corners.

 

[Olaf Doschke]

Autonumber is a term in ACCESS, are you really using SQL Server?

In SQL Server such fields autmatically numbering are INTEGER IDENTITY, and there are several ways to get the latest value of any IDENTITY field, of a certain table or a certain connection.

See

http://blog.sqlauthority.com/2007/0...nt-retrieve-last-inserted-identity-of-record/

And in Access Autonumber fields you have @@Identity, too.

See

http://stackoverflow.com/questions/1628267/autonumber-value-of-last-inserted-row-ms-access-vba

Bye, Olaf.

 

[philhege]

Wrap your statements in a transaction. Create a stored procedure that does the insert and returns the primary key as an output parameter.

-------++NO CARRIER++-------