Generating Report from Form filtering

[oica72]

Hi,
My database contain one table, one form and one report.
I want to filter the data on the form by using a combo box and a list box and then, after pressing command button Print, I want to generate a report with the filtering data.


Thank you in advance

[June7]

Try:

1. set criteria in report RecordSource that refers to the controls on form as input parameters

or

2. use WHERE argument of DoCmd.OpenReport:
DoCmd.OpenReport reportname, , , "fieldname1='" & Me.comboboxname & "' AND fieldname2='" & Me.listboxname & "'"
If data is number remove the apostrophe delimiters, if dates use # delimiters.

[dblife]

Or you could base your report on a select query and have the criteria for the select query as the combo on the form?
Either method will work but this method ties your report to this form.
June7's method keeps your form free for use by other forms.

[oica72]

Dear June7,
Could you please help in this particular example? I tried to implement your advice but I failed

Thanks in advance

[June7]

Which method do you need help with? What did you try to implement? Why didn't it work - error message, wrong results, nothing happened?

For #1, check this tutorial http://datapigtechnologies.com/flash...tomfilter.html

I can't view your database for 2 weeks (vacation).

[June7]

Problem appears to be the search criteria are dates but you have formatted the search for text string. Review the attached modification of your project. I will remove the file after you respond or in a few days.

EDIT: purpose served, file removed.