MS access getting autoNumber value

[Anon]

Hi,

I know MS access is average but I need to use it :-)

My question is, how do I return the primary key autoNumber value of a newly inserted record?

In other words the MS access equivalent of mysql_insert_id() in mySQL or the @@IDENTITY command in MS SQL.

Your help is greatly appreciated.

Thanks.