INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

REPORT FILTER DOES NOT WORK

REPORT FILTER DOES NOT WORK

(OP)
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?

RE: REPORT FILTER DOES NOT WORK

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close