I have a report that is based on a query. The data in the query is used to determine exactly which fields from the query print on the Report. The criteria for the query is a value from a text box on a form in the database. If I open/run the report directly from the Report Object, it prompts me for the value of the text box, and then prints the data correctly. However, if I print the report from the form using "stDocName = "rptPrintCRQuote"; followed by "DoCmd.OpenReport stDocName, acNormal, I do not get all the fields correctly. I have tried putting my code on the Load, Activate, and Current Events - all of which seem to be fine when opening report directly, but when called from the DoCmd the code does not seem to be executed and I can't seem to use the debugger to see why not. Wondering if there is a different Event that I need to have my code on or why this only works when running the report dierectly? Any hints or suggestions would be very much appreciated.