That worked! Thank you! It prints the data when it's filtered and when it's not filtered. Brilliant! I am a novice with VBA, I would not have come up with this solution.
I get the "Enter Parameter Value" popup box too with this code. It is asking for "SearchQSubform.Recipients" input. The column that is being filtered by the user is "Recipients".
Record source for both the sub-form and report are the same (SearchQ). I get the "Enter Parameter Value" popup box that asks for "SearchQSubform.Recipients" input. The column that is being filtered by the user is "Recipients".
My end user is using a filter on a sub-form (SearchQSubform) then pressing the "PrintPDF" button that is located on the form (SearchForms). However, all the searched data in the sub-form is printing. I only wish to print the user's filtered data. I tried putting the following code in the "On...