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!


Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I'd build a function that would accept a value (whatever ID value is needed to properly open your detail form), then call that function as needed. You'll generally need to use several different double-click events in a form to insure that users can d-click anywhere they want to show your detail form (eg the form's DoubleClick, each controls, DoubleClick, etc).

To open a form to a specific record, you use the WHERE argument of the OpenForm method:

DoCmd.OpenForm, "FormName", , , "SomeField=" & Me.SomeValue
canuckconsultingAuthor Commented:
Thank you!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.