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