What database are you using?, different databases will require varied
techniques.

"Les Juby" <webprowebpro.co.za> wrote in message
news:3f2a5c2b.25434833news.uunet.co.za...
> Is there any way I can get the value of an autonumber field directly
> after adding a new record into a table with the INSERT INTO command.
>
> It would be a real resource gobbler to have to loop through the entire
> record set filtering for a field value........
>
> .les.
>
> o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o
> Les Juby [email]lesjubyanti-spam.iafrica.com[/email]
> Webpro Internet - - - Prosoft Microsystems
> Durban, KwaZulu-Natal, South Africa
> P.O.Box 35243, Northway 4065, South Africa
> Tel: +27 31 563-8344 Fax: +27 31 564-4928
> o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o-o
> (you *do* know to take "anti-spam" out the address....?