Unanswered: Access 2007: Problem printing report with filtered data
I have a form that uses an unbound combo box using a qry for a source as does the subform. This data is for viewing not editing. I filter the datasheet using the column heading dropdown but I need to create a button that will allow the user to print a report using the filtered data from the datasheet. Using the vb statement:
Try pulling the Filter property while it's showing you the right data. See what the form's filter is set to. If it's not set or not fully describing what is being viewed, then I would say there is no way to do it with datasheets.