Ian,
Thanks for the help, but I'm still having problems. I set it up the way you said and it still won't work. I have a form that has the buttons on it that the users click to run the report. It is here that I am passing the sql WHERE clause on to the report using the DoCmd. The report is where...