[AccessD] Finders problem

Arthur Fuller fuller.artful at gmail.com
Wed Jul 16 16:36:47 CDT 2008


I have two controls on a form that I call "Finders". They are
straightforward dropdowns listing the Site numbers and Site Names. The
problem I'm having is that once I execute the Filter By Form code, the
Finders still list the entire recordset. Suppose that the original recordset
has 50 rows, and you then execute FBF, reducing the set to 10 rows. How can
I refresh the rowsource of the Finders to exclude everything but the 10 rows
isolated by the filter?

I'm using code by Stan Getz to do the filter operation and it works great.
No issues there. The only question is how to refresh my Finders after an FBF
operation. They start out as "SELECT SiteID, SiteName FROM Sites" and so on.


So now the user imposes a filter, and the result is that the filter property
now says "(([SitemCity] LIKE "Toronto*") AND ([SiteUTMnorth] = 0))". So do I
just change the rowsource property of the Finders to concatenate the filter
to the previous rowsource? And then when the user kills the filter, change
the rowsources back to their original values (I could store that in their
Tag properties and then just grab it back from there).

I hope this explanation was clear enough to give you the picture.

TIA for any advice.
Arthur



More information about the AccessD mailing list