I am working on a database in Access 2010.
I am trying to create a report that appears once a specific combo box is filled out for a particular field in the form I am working in. Basically, when a value is put in the combo box, the combo box will filter the form for all the records that match the criteria in the combo box. The filtered records should then populate into the report that appears.
The reason why I need this report is because I would like to be able to view all the of the particular records and be able to sort for various fields more efficiently.
Please help me with this problem.
If you can solve this I would really appreciate it!