Using MS Access 2007 I have an application to track the tasks I am working on those completed. I have written the form frmDetail which allows me to add, modify and view the details of a particular task.
I want to have another form frmSearch displaying a list of summary information of all tasks in the system. The list will allow me to filter by status (open, closed, etc) dates and so on. I can put this together but I'm not sure how to have it set so double clicking on an item would open frmDetail with the details of the selected item.
There are a lot of details so i don't have the space on the form to build a master/detail on this so am expecting to put a button Search on frmDetail which will pop open the filter form. Double clicking an entry will open it and there will also be Print button to print the selected tasks in a report. I'm just hazy on how to get the forms to work together!