I have this code in the onclick code of a command button on a form...
Me.Filter = "ListApptBestAgentBusiness" = -1
Me.FilterOn = True
DoCmd.OpenReport "rptListingAppointmentsSet", acViewPreview, "", "", acNormal
The report is supposed to be displaying only the records where ListApptBestAgentBusiness is True
But it is displaying all records and not filtering. Thoughts?