[AccessD] Save on Report Close not working

Susan Harkins ssharkins at gmail.com
Thu Mar 19 12:12:02 CDT 2009


Private Sub Report_Close()
  'Reset filter property

  DoCmd.OpenReport "rptCustomerLabels", acViewDesign
  Me.Filter = "PrintLabel = -1"
  DoCmd.Save acReport, "rptCustomerLabels"

End Sub

========I added this to a report's Close event -- it's an existing report 
solution and I don't want to completely rework it to add this simple 
feature. I'm resetting the Filter property, but the original report relies 
on the Filter setting above, so I have to reset it and save the report --  
but it just doesn't work. It doesn't even seem to fire! I'm closing the 
report from the Close button.

Susan H. 




More information about the AccessD mailing list