SteveL13
asked on
Trying to open a report with a filter
I have this code in the onclick code of a command button on a form...
The report is supposed to be displaying only the records where ListApptBestAgentBusiness is True
But it is displaying all records and not filtering. Thoughts?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER