How to move cursor on my desired position specifying primary key
Hi,
How is it possible that PK has same value in several records? Is it compound
PK (multiple fields)? What you could do is to sort your recordset by PK
field(s). Then use Find to find first record. Now you have only one chose -
look though the records and find first matching. Since recordset was sorted,
you do not have to loop through all the records in a recordset, but just
through those one, which have same PK value
--
Val Mazur
Microsoft MVP
Quote:
> I want to move a cursor on my desired position in a recordset
> specifying primary key. If primary key is single, using Find method
> is useful. But primary key in my table is multiple. I tried Filter
> property, but the effect didn't match my expectation. It changed
> the recordset by filtering.
> Does anyone give me good idea? Thanks in advance.
> Takashi Masuda
