Report filtered by combo box

Clownfish1980m

Clownfish8182m
Local time
Today, 12:35
Joined
Sep 18, 2009
Messages
40
I have tried to research this but can’t find exactly what I want to accomplish. I have created a database for my wife whom is working as an independent consultant. She visits various practices and provides support on the EHR systems. She wants to have a report to take with her identifying the tasks she needs to work on when she goes to the various practices. I have three tables, Practice Tbl, which identified the practice name; Task List Tbl identifies the specific task and a TASK Tbl which is linked to the other two tables. This is the table that will store the specific information. I built a form called Pending Tasks by Practice. On this form I have a combo box that allows the user to drop down and select a practice and then a command button that allows the user to see the task pending on another form. I want to build a report “Task Reported by Practice” where the user can select a specific practice and then have a command button open the report instead of a form listing only tasks specific for that practice. I can currently open the form but it shows all practices and tasks pending. Thanks Ken
 

Users who are viewing this thread

Back
Top Bottom