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.