What is the best way to Filtering Data

[philliplaw]

I am new to Access and working on my first project.

I am displaying information based on a Combo Box.
The first time, I created a "Query" and displayed that in form. Then I figured out how to do a "Filter" within the form.

Are there any advanatage or disadvantes to either method?

Thanks.

 

[randy700]

If it should ALWAYS be filtered, I'd do it in the query.
If it's a "sometimes" thing, in the form.


Randy