There are two reports in a value list text field and also a text field with
a list of quarters on a form,like, "FY 01/07, FY12/06, FY11/06 etc. This
code opens the report based on a query but it doesn't filter it. In the
query of the report I have this same fiscal year period field. The field is
called FY Reported but that is a typo it is really the Fiscal Quarter I don't
want to change anything.

How do I apply the filter in the code? The Select query would be something
Select * from queryXXX WHERE [FY Reported] = me.fiscalQtr?
Where do I put the select query and how do I apply the filter so it opens
the report with only the quarter requested?
Private Sub cmdGetReport_Click()
'On Error GoTo Err_cmdMediatorEvalCum_Click
Dim stDocName As String
Dim stFiscalQtr As String
Dim strFilter As String

stDocName = Me.ReportName
stFiscalQtr = Me.FiscalQtr

DoCmd.OpenReport stDocName, acPreview, , strFilter
End Sub

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question