I'm sure I'm missing something really obvious here, but how do I retrieve
the value of an itentity field when adding a new record.
When using AddNew, the identity field is not set until the Update occurs, by
which time I've lost the new record.
I used to use rst.LastModified with DAO. Is there some equivalent in ADO,
or is there a way I could acheive this with subqueries?