Filter from drop down in output report

[Bertrand82]

Hello Guys,



I have a very simple vba code according to below where I export a pdf report.

Q: I have a field in that report called "Company". I would like to filter that report with a drop down text box named "Companyfilter" where I choose a Company to only include values from that Company in the report.

How do I change the code below?

Thanks in advance!


Private Sub RunReport_Click()

DoCmd.OutputTo acOutputReport, "rptNameOfReport", "PDFFormat(*.pdf)", "H:\xxxxx\reports\nameofreport.pdf", False, "", , acExportQualityPrint


End Sub

[ranman256]

This would not take place here....the QUERY that is in rptNameOfReport would handle it.
On your form you would have the combo box for company...cboCo

the query would have criteria that sees the combo... where [co] = forms!frmRpts!cboCo

your RunRpt click would not change.

[Bertrand82]

yes I have the drop down list box on a form.

I suppose I shall include a sql string in my vba code?

[IslandHydro]

You can use the AfterUpdate event on the combobox to open the report with a filter like so:

cboCo_AfterUpdate()
Docmd.OpenReport("ReportName", acViewPreview,,"[co] ='" & cboCo & "'")
End Sub