recordset .findfirst question

[RonL]

I'm getting a nomatch on:

.FindFirst .Fields("fldSortOrder") = 4

even though I know that record is in the recordset (because I can loop through and debug.print it). I've tried putting a .movefirst before it, no help. Also changing the syntax in several ways, all of which produce an error. The above syntax doesn't produce an error; it just doesn't move the pointer.

Any thoughts?



Thanks, Ron

[rzw0wr]

post all of your code and be sure to code wrap it.

Dale

[Bob Fitz]

Try:
.FindFirst ("fldSortOrder=4")

[RonL]

Try:
.FindFirst ("fldSortOrder=4")

That works. As does .FindFirst ("fldSortOrder= " & intRankCur) , which is really what I was after. I won't pretend to understand why the .fields() function doesn't work in this context.

Thank you!

rzwOwr in case you were wondering, it's a dao.recordset, created by a query and passed to a subroutine as a dao.recordset.

[rzw0wr]

I was thinking that.

Dale