Help with Filter and FilterOn

  • Thread starter Thread starter EAB1977
  • Start date Start date
E

EAB1977

Can anyone tell me why my filter doesn't work when I click the button
to run a report?

Private Sub btnCost_Click()
DoCmd.OpenReport "rptCost", acViewPreview
Reports("rptCost").Filter = Me.lstResults.Column(0)
Reports("rptCost").FilterOn = True
End Sub

The filter does not seem to be set when the report runs.
 
Did you mean to post this to an Access group?
Can anyone tell me why my filter doesn't work when I click the button
to run a report?

Private Sub btnCost_Click()
DoCmd.OpenReport "rptCost", acViewPreview
Reports("rptCost").Filter = Me.lstResults.Column(0)
Reports("rptCost").FilterOn = True
End Sub

The filter does not seem to be set when the report runs.
Click to expand...
 

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

Similar Threads

Help with Filter & FilterON 2
Excel Export Filtered Form Data To Excel 0
Filter by date range for any one of three dates. 0
How can I filter by Dates on a Form? 6
Printing Report for one a single record - Several problems 5
ACC2000: changing report .Filter does not work 3
Refreshing filter on Subform in Access 2010 0
Setting Filter and FilterOn properties of a report from code. 3

Back
Top