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.