Remove Filter by Selection levels

  • Thread starter Thread starter sps
  • Start date Start date
S

sps

Is there an easy way to back up one level when using
filter by selection on a query result? In looking for
some specific records where I do not have sufficient
information to find them, it is often easier to filter
down the recordset on what I do know. However, if I go
too far (make the wrong filter choice), I need to be able
to back up one level and make a better choice.

I would also like to provide a similar functionality to
the user through a form based on the query.

Any ideas would be appreciated.
Thanks.
Steve.
 
sps said:
Is there an easy way to back up one level when using
filter by selection on a query result? In looking for
some specific records where I do not have sufficient
information to find them, it is often easier to filter
down the recordset on what I do know. However, if I go
too far (make the wrong filter choice), I need to be able
to back up one level and make a better choice.

I would also like to provide a similar functionality to
the user through a form based on the query.
Click to expand...
Hi Steve,

I might use "cascading combos" to filter the
data in your situation.

I believe Roger Carlson might have an example db
on his excellent site that will get you started

http://www.rogersaccesslibrary.com/TableOfContents3.asp

or the Solutions9.mdb has a cascading combo example
(plus adding "ALL" to combo list)
http://msdn.microsoft.com/library/en-us/bapp2000/html/bapp2000.exe

The point being that combos at "end of cascade"
could have an "ALL", that user could select when
"gone too far."

Good luck,

Gary Walter
 
Back
Top