Access - Identity Key

[Aaron Coombs]

Hello,

Is it possible to retrieve the Primary Key(Autonumber) for a new record
after insertion? How can I pass values to an append query stored in the
access database and get the primary key id in return?

Thanks,

Aaron

[Venu]

Dear Aaron:
If I understood your question correctly,

add this code
adodc1.recordset.requery
This should bring up primary key(autonumber) on to the form.
You should also need to add additional code for making sure
adodc1.recordset.movelast
This will move the recordset and user can see the Primary key.
I hope this is helpful.
Let me know.
Venu

"Aaron Coombs" <a.coombs@home.com> wrote:
>Hello,
>
>Is it possible to retrieve the Primary Key(Autonumber) for a new record
>after insertion? How can I pass values to an append query stored in the
>access database and get the primary key id in return?
>
>Thanks,
>
>Aaron
>
>