I have a Sql table (Pur_head) with the primary key (ReqId) set as the identity. The last record in the table shows the ReqId as 58873, so the next record might be 58874, I would expect.

The Pur_head.vb shows this as the primary key as well.
When the code creates a new record, the textbox that shows the ReqID shows 58874. This might have been correct.

Instead the actual last record, using SQL Server Enterprise, shows the ReqId as 58954. It's this number because there were a lot of records deleted from the Sql table.

So why isn't the textbox showing 58954?

Thanks.