I have an unbound text/list box that uses a SELECT FROM statement as its record source. It is basically a search results form from the user entering first and last name, but it searches for either instance (first or last name), so if I enter "John Williams" it gives me all the johns and all the williamses. The problem is that the list box doesn't show all the values. It will only return a small set of them (alpha sorted, it sometimes ends on last name C-- or D--- or L-- or M--; random every time). I checked the max records property of the query and everything else I could think of, and it seems that the problem lies in using the scroll bar.

Once the records are returned in the list box, if I scroll through them using the arrow at the bottom of the scroll bar, I can get to the end of the list (Z--) no problem. However, if I try to page down with the scroll bar, the list ends prematurely.

ANY ideas?????

In order to speed up response, Access may return results to a form before the entire recordset is fetched from the server. Using the down arrow probably scrolls the list slowly enough to keep ahead of the row fetching going on behind the scenes.