I have a query (qryInventory) that displays inventory items. I created a read-only form (frmInventory) that displays the query results in datasheet view. The purpose of the form is to allow the user to sort and/or filter the data by using the built-in datasheet menus. Finally, I have a report that is also based on qryInventory. I would like the user to click a button a generate the same report, but display the records that have been filtered in the datasheet. I am trying to avoid having to setup 20 comboboxes that are used to filter the query directly.
Is this possible?