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.Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9443-subform-stops-at-1800-returns.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9443
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.