Launch details form by double clicking item in summary form

Posted on 2010-01-06
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 84

    Accepted Solution

    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

    Thank you!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now