ASP / HTML Form + Autonumber

Hi all,

I'm trying to create a form which, once filled in, submits it to the required email address, and into a database to record the submission.

I can achieve that, but I'd also like each form to have a unique ID, ie the AutoNumber in the database, and for that to be emailed to the address at the same time.

Does anyone have / know of any code to do this please?

For example, someone fills in form, they click submit, the details are entered into the DB, the AutoNumber is pulled back and all the details, with the AutoNumber are emailed to the person.

Any help would be greatly appreciated!

Thanks

Sorry to sound cheeky, but do you have an example I could work from?