I need to come up with a way to create a report based on selecting certain criteria. What i have done is created a form where i can select from a combo box the criteria i want. I can only create a report one selection at a time this way. I can create a report that includes all the records and from the report view i can click on the filter button, then select or de-select the criteria to filter the report. I have yet to find out a way to do this in a way that will work in the runtime version. The menu bar is pretty much non-existent in the runtime version. The little pop up window that comes up when you click the filter button is exactly what i want to do but don't i'm not really sure how to accomplish this in a way that will work in the runtime version of access.
This is what I have now. But your example tells me you understand what I’m trying to do, that is good. In you example you can select from different employee ID's. I want to be able to select multiple ID's. For example I would like to create a report that included ID, worker ID 100 and 101. You only have four criteria to choose from where I will have around 20. If I print out the whole list it would take way too long and a lot of paper. What you have here Is what I have now, essentially one at a time.
To select multiple employees, you can make the selection part of a table. Either a select flag (Y/N) for each employee (in the employee table) or a separate table that stores the IDs of selected employees... or you can use multi-select list boxes, but I hate them for some reason