Link to home
Start Free TrialLog in
Avatar of canuckconsulting
canuckconsultingFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Launch details form by double clicking item in summary form

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!

Thanks,

Scott
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of canuckconsulting

ASKER

Thank you!