Same here.. but you may be able to read the value from the recordset immediately after the add.
If not, open a recordset with this SQL statement:
..this will return a single field containing the last auto-generated value (for ProjectID in this case).Code:Select @@Identity




Reply With Quote