REPORT FILTER DOES NOT WORK

[jmc014]

Hi,

I have a real simple problem that is becoming to be something unbearable.

I have a report based upon a table called "Services" that I would like to open/print with a filter:

DoCmd.OpenReport "Services_Database", , "General_Services"

But this, for some reason or another, does not seem to work!
I have placed the "General_Services" filter directly on my report's recordsource and it works, but when I apply the above code, the report prints my report with #Name? all over the place!

I have put the above into practice 100's of times before, and never had any problems, so I wondering why it's not working this time?
I've tried changed the filter settings to true, false, and all sorts of other trial and error settings, but it's not my day!

I'm using MS Access 2013 with an SQL2014 Server backend on a Win 10 Op system.

Anyone got any ideas?

 

[jmc014]

I might have been a little too quick...

I got the problem solved by putting the below line into the report's on open event:
Me.RecordSource = strSQL

That also solved another problem I had, but that's another thread!

Thanks to anyone who was going to reply
JMC014