access to auto increment values

[avi weiss]

I have a record set that Im using to add data to a table. the table has an autoincrement field in it. I set the individual values of the record, after which I do an update. I immediately try to access the auto-incremented field via the recordset object, but the value is shown to be "empty".

querying the table shows the record has been updated and the autoincrement value in the field is there.

anything special that Im missing that needs to be done to access the autoincrement field?

thanks

-avi