Filtering Query Based on Criteria

[McArthurGDM]

Hi,



I have a multiple item form that displays query results.

Along side this I have an unbounded search form.

I would like to add filters to the query results. That is, if i were to have a list that says A-Z, Z-A, that it would filter records by alphaetical order. Or it will do it by date. I also would like multiple filters per search result if possible - not just one.

Im not sure how to go about creating this though.

Any thoughts?

[June7]

Options for filtering records:

1. open table or query and apply filter with the intrinsic Access sort/filter tools

2. static criteria manually typed into a query design or dynamic popup parameters in query (I NEVER use query popups)

3. open form or report based on query and pass filter criteria to the form or report object
Review:
http://www.datapigtechnologies.com/f...tomfilter.html
http://allenbrowne.com/ser-62code.html