Finding a record

[Rick West]

On a sub-form (datasheet view) when we do a "find record", it finds the record but the record is always slightly below (or under) the bottom of the forms edge and we have to scroll down another 4-5 records to see it. Very annoying.

I probably have some property set which makes this happen but I don't know which one it could be.

[llkhoutx]

Your "find record," whatever that is, is returning multiple records. A datasheet view only shows records which satisfy the specified criteria.

[Rick West]

I guess I wasn't clear.

The record is being found and highlighted but it is below the lower edge of the form so it is not immediately visible. Scrolling down a few records brings the found record up into viewing range.

Most of the time, when looking for a record, the datasheet scrools down and brings the found record into the viewing area automatically.

Am I making sense?

[llkhoutx]

You say

The record is being found . . .  Scrolling down a few  records brings the found record up into viewing range. 

This means you are retrieving multiple records. How is the desired record differentiated from the other records displayed? You want a filter that retrieves only the desired record.