Hi everyone
I need a little guidance about how to filter a report using a form that has two combo boxes as well as a date range. Basically the user is already on a main form (frmMain) and a button is present if the user wishes to view the info as a report, when the user clicks on this button, a form called frmReport will open prompting them to fill out the criteria which ideally will open the report. I've been fiddling around with this and made a form with a combo box and two text boxes as set to "Short Date" and a query that selects all the appropriate data as well as a report that will display everything. My issue is just filtering what the user selects and making the report appear. I've tried looking at a couple public resources but unfortunately I don't know how to make the form open directly. When it comes to reports and access in general i'm still very new. If anyone has a link to any reliable resources or advice, that would be much appreciated.