Launch details form by double clicking item in summary form

Posted on 2010-01-06
Medium Priority
Last Modified: 2013-11-28
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!


Question by:canuckconsulting
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 26189489
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

Author Closing Comment

ID: 31673411
Thank you!

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question