Access Append query--identity key

[Elsa]

Hi All,
Do you know how I can retrieve an autonumbered primary key from an Access
saved append query? What I am trying to accomplish is similar to what SQL
server allows one to do when running an insert stored procedure.
Where the insert runs first and then the identity (system-generated) key can
be
retrieved by coding "set @MemberID=@@identity".
Does Access have a way to accomplish this?

Any suggestions and directions are much appreciated.
Thanks,

cstech

 

[JohnFol]

Have a look at the DMax function.