I have a form whose recordsource is a linked odbc table in a sqlserver 2005
database.
I've found a case where the record displayed in the form isn't the same as
the one in the form's underlying recordset!
I've managed to narrow down the problem to the following:
the following table:
create table test(id int not null primary key)
has about 30000 rows with specific non-consecutive numbers.
Form1 is a simple form in datasheet view.
when I execute:
forms("form1").Recordset.findfirst "id=142731"
the form's selected record shows id 110885
and executing:
debug.? forms("form1").Recordset("id"), forms("form1")("id")
gives:
142731 110885
The same happens using the recordsetclone/bookmark method:
Set rs = Forms("form1").RecordsetClone
rs.FindFirst "id=142731"
Forms("form1").Bookmark = rs.Bookmark
debug.? forms("form1").Recordset("id"), forms("form1")("id")
gives the same results
This only happens with the specific data currently in the table. I tried
filling the table with other data, and there was no problem.
I can send the data to anyone who's willing to check the problem.
I got the same results on 2 different machines with Access 2003 SP3 and
SQLServer Express 2005.
