[AccessD] Getting the Primary Key of a New records in Oracle

Does anyone know how I can retrieve the primary key value from a new record just added to a linked Oracle table using VBA?

I.e. I create a records using VBA, populate the fields with VBA and update the record. How do I then find out what the primary key value allocated by Oracle is? The key field is of type NUMBER(10) and it is populated by a trigger (which I have no control over).

Lambert