I'm trying to run a search feature that will impose a filter onto an open recordset and display the filtered records. It works correctly, but when I try to display at the bottom of the page "Record # of ##", using the absolute position and record count properties, I'm getting the wrong data. To get the data, I have:
Fairly simple, right? And the record count gives me the correct number of records, but the absolute position gives me where that record would be in the unfiltered recordset.

Which means I'm displaying thinsg like: Record 7 of 3, as the first returned record. What am I missing?

Try using "rsPerson.CursorLocation = adUseClient" if not using already...

Cheers
Prabodh