Hi Stephen. I'm not sure what you don't understand. Explain to me the problem, please. Do you need more help understanding string concatenation?

Hello Richard;

No, I'm having trouble understanding / programming my reports to show the data I want.

I have a complex search form with more than 30 different combo box fields for which I have vba written to look up data according to the values selected (additionally with tri-state conditions). Everything works great for showing the desired data in a form when I run the vba.

My trouble lies in trying to translate that into a report.

I am able to get a "start date" and an "end date" to work together for a report. But when I go beyond that I start getting parameter query boxes popping up on the screen asking me for values that it should be getting from the search form.

I know you state in the Search Seminar 34 Lesson that reports don't function the same as forms and then you go into creating "Wh2" as a means to work around this but I am not understanding how to code it.

Figured it out. Sometimes you get so in depth into complicated coding that you forget basic things. So, in this instance I had forgotten to add the correct fields to the query...resulting in multiple parameter boxes popping up.

Send me back to remedial MS Access.....

That'll do it, every time. That or misspellings. :)