Is there a Way for making a form to filter searches for Reports?

[rodvaN]

Hello there..
Well what Im trying to do is to create a form that has an option to select with variables search for data for creating a report.
For example
- Cars ____________ if i type what car im looking it will automatically create a report for it
but if:
- Cars ___Mustang__
- Year ___1983___ It will create a report for all the mustang cars of the year 1983 the client has.
And if:
- Cars __Mustang__
- Year __________ Empty
- Color ___Red____ This will create a report with all the mustang cars from all the years and all of them red.
So i got like 10 variables..
Is there a way for making combinations in a form for this variables and at the end creating a final report?

Thanks in advance guys.
Yours
rodvaN

 

[neileg]

Yes, you combine the Like operator and the wild card.

Say you have a form called frmCarPicker, and there's a control called txtModel, then in the query that you run, put a criterion in the model column:
Like Forms!frmCarPicker!txtModel & "*"

This way, if you choose Mustang, the criterion becomes Mustang* so gives you all records that begin Mustang, if you enter nothing the criterion becomes * so returns all records.