Code from Form to Report

[businessman]

I have written about 23 pages of code to make a series of checkboxes filter my form the way I want it to. How would i Move that code over to the report so that it will display only the filtered records that show up on my form? All I want is to use my form to filter records and then be able to print a report that shows everything about those filtered records on the form. There seems to be too many confusing things about access that I still don't know or understand. I did try and say in the report button i created saying "DoCmd.OpenReport stDocName, acPreview, , Me.Filter". When I do that it askes for some parameter that I can't get rid of.

 

[llkhoutx]

When I do that it askes for some parameter that I can't get rid of.

means that the field being prompted for is misspelled.

 

[businessman]

there is no place where i spell that parameter or where i call it. unless its hidden somewhere

 

[llkhoutx]

If it wasn't there, you wouldn't get a prompt. If your querying a query, drill down every level looking for it.