Hi all, I have a subform that returns records based on a filter from the parent form. The subform is connected to a query that is in turn connected with a table that is associated with the main form and query. There is a large number of records, 4000+ that should be returned when the filter is run, however the subform is stopping at exactly 1800 records and not erroring out. When I close the form and reopen it with the filter still applied, or I requery the form again it then returns the 4000+ records I am looking for. Why does the subform stop at 1800 returns exactly? Is it an access bug? Is it a refresh timer? Any info would be appreciated, thanks.