>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.


I dunno, but why would you want to show a PK in a textbox?

Here's hoping all is well in Maine. It's looking highly unlikely that I will make it out there this summer.