How can I get the primary key from a newly inserted record

[Guru2B]

Hi,

I have an object that writes a record to an Access DB. I'd like to know if there is a way to get the primary key for this newly added record at the time the object is written.

I am using ADO 2.5 with VB 6.0 I know that with DAO, I was able to get the value before calling the update method, but this doesn't seem to work with ADO.

Please help.
Thanks.

 

[luke911]

I did it by adding a time field then calling where time equals (display number)