Search not filter and display results in subform.

[Cesar Zapata]

Hi,

I have a small split DB BE and FE. I need to implement a search form
where the results shows in a subform. I tried this http://allenbrowne.com/ser-62.html
which is good but because there are about 2000 records and the BE is
in a share drive it takes a while for the subform to load to show all
records before I can filter.

what I need is a "on the fly" filtering or search. I think I have to
use SQL and build a query on the fly or is there a faster way?

any ideas will be a appreciated.

thanks!