View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EAB1977 EAB1977 is offline
external usenet poster
 
Posts: 39
Default Help with Filter and FilterOn

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.