Sorry i dont follow, What is select case? Are you selecting a record or changing the text capitalization?

Hello Adam. Let me see if I can get out of my Spanglish mode.
I am trying to print a report based on select case.  I have the report set up but will like to send the recordsource to the report to print in the selected manner.

V/r
Juan

Sorry Juan, I still don't understand the select case part. You're just making a record source with a SQL statement and then want to send that to the report though?

yes

So I just tested passing to a report. This is passing a SQL statement setting a rowsource for a listbox. I'm pretty sure you can use Forms!FormName.recordsource instead. This works for me in the on load event of the report to set it's record source.

Private Sub Report_Load()
Me.RecordSource = Forms!PartSearchF!PartList.RowSource
End Sub

If you're not using that SQL statement to make the record source of the form. You can also do the old hidden text box and set it to hold your sql statement then pass that over too.

It works Awsome.... Thanks Adam.

Adam -
Select Case is an Access Function.  Richard has not covered it in great detail though if you search it there are some links.

Here is another link with a description and examples of use that you might find helpful:

https://www.techonthenet.com/access/functions/advanced/case.php

OH that's jacked, I was trying to see who else liked it.....I got pooped.

same thing happened to me a few days ago LOL

I guess Rich still needs to do the TH mentioned on your previous post

Hi guys. Sorry I took the day off yesterday and missed this whole conversation. I've covered Select Case in a few Developer classes (like 2 and 13) but I haven't covered it in DETAIL yet. I'll add it to my list. I try to keep the TechHelp videos short, so I could cover the basics in it, but the meat and potatoes will take me a lot longer - Ext Cut at least, but since I haven't done this in a Dev class yet, that's where I'll start it. It is handy, but it's really just a way of shortening an If/Then/Else block. Both can do the exact same thing. And yes, I like Adam's hidden text box to pass the SQL string. That or you could use TempVars, another concept I have to cover fully. I do cover opening a report with custom SQL in the SQL Seminar Part 2, but I could probably do a little bit about this in the next Dev class too. So much I have to cover still. I'm queuing up D28 now.

Haha... Juan's comment that he got pooped... I've always found it hilarious when people on sites like Facebook LIKE their own posts. So go ahead and see what happens if you try to LIKE your own comments here. :)

Hi Juan, Maybe you could add a button on your report and try

Private Sub cmdPrintTypeReport_Click()
   DoCmd.SelectObject acReport, Screen.ActiveReport.Name
   DoCmd.RunCommand acCmdPrint
End Sub

HTH  John

You are so funny I got a kick out of it.

V/r
Juan

John Thanks But Adam pointed me in the right direction.

V/r
Juan