Im adding a new record to a database using ASP.

The problem is i want to create a new record which i can do fine, and get the ID fields value that is set to autonumber, whats the easiest way to do this?