Getting previously inserted auto id

[Roost3r]

Hi, any way to get the id of a auto incrementing field that was just inserted? tia

[whammy]

Are you using SQL Server? If so check this out:

http://www.kamath.com/tutorials/tut007_identity.asp

[Roost3r]

im using access

[whammy]

Ok, this might help then:

http://www.flws.com.au/showusyourcode/codeLib/code/AddNew.asp?catID=3

:D