>For this purpose, I would change the structure and add a candidate key so you could retrieve the PK value using that. Otherwise, I don't know of any way with Access.

Thanks for the suggestion Larry.

>
>FWIW, if you ever decide to go to SQL Server on the back-end, you can get this by retrieving @@IDENTITY after your insert.
>

Interesting tidbit. We are actually in the process of migrating some DBs to SQL Server, so maybe it will come in handy. Thanks again.

Jon