[AccessD] Finders problem

"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"

Sounds like the right thing to do.


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Wednesday, July 16, 2008 2:37 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Finders problem

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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com