Thanks for the info. However, to make things more fun I took the bookmark out of it.
I'm using this in the combo box with the string explicitly set
Me.RecordSource = "select * from Party"
Call Me.Recordset.FindFirst("[ptyrfnbr] = 51756")
51756 is for the pary Smith, Joe.
I put a stop breakpoint right after the
Call Me.Recordset.FindFirst("[ptyrfnbr] = 51756")
line and added a watch on Me.Recordset.
The fields(0).ptyrfnbr shows 51756, lastname shows smith and so on. I step through the code and the form_current fires. And the ptyrfnbr now equals 9852, lastname is different etc.
This only happens with a linked table to SQL server.
If I create a local table with the same definitions of the linked table and copy the data I don't have this problem.
I even used the upsize wizard to copy this new table (party2) to a new database and did a link to the new database and table. Once again, same problem.
I've also installed SP3 for Office and SQL Server 2000 so I believe I'm up to date on all patches, etc.