Thanks for the code, but I am a bit confused. The filtername is the name of my query? Also you have the below code:
DoCmd.OpenReport "reportname",acpreview,,"CROP_Code = " &
YourForm!YourControl
What is CROP_Code? Is this the name of the field I am using in my query?
You also...