Hi,
I have a form that will create a report based on selected criteria in my form. The form pulls from tables and the report is generated based off a query from these tables. My problem is the report generates, but it shows up as a blank report and I also don't know how to ensure it will report only the selected information I chose in the drop down menu.
I attached my access database. I use Access 2016. I had to compress it as a zip file because it is slightly over the attachment size limits of the forum.
Please open 'data entry' form and make selections in the drop down. Please make sure to click on the buttons next to the drop downs as I had to do this to ensure the menus refreshed properly.
Now as I said, when you click on Open Report button, it only opens an empty report. It doesn't create a report based on the information selected in the drop down menus. If you open my query in Design View, you will see the criteria I wrote. I placed the same criteria for all the drop down menus.
Where is it going wrong? Where do I update? Is the criteria correct in the query? Please advise. Again, I am a beginner and use Design View. I don't use too much coding.
This is the last step of my report generation and urgent. If I can bring up a report based on drop down menu selections, it will be completed. thank you in advance.