Double Clicking in a field

Posted on 2011-10-06
Last Modified: 2012-05-12
I have a form called “Scheduling-Add” with a query "qryScheduling" as the Record source . When the record has a "ProtocolNbr" data in the field next to the "Studies" button“ field I want to double click in that field to open the “Studies-Edit” form to that record. The "Studies-Edit" form record source is the Stdies table How can I accomplish this goal. Attached is a copy of the database with the forms .
Question by:Chrisjack001
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    I really don't like "Double clicking" a control (Textbox, combobox) as an interface feature...

    This requires all users to magically "Know" that this can be done.
    (Then it has to be clear what this will do anyway...)
    Then users will start double-clicking on everything just to see if anything will happen

    I would rather just put a button next to the control that "Clearly" states what it will be doing.
    (I thought the purpose of this app. was to be "Easy/Simple" for the user to navigate...?)

    Just my 2c

    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    On the other hand,  I like double clicks, especially in people and company combo boxes.  I usually set these up so that a double click will open the People (contacts) form or the Company forms.  Normal syntax for that would be:

    Private Sub cbo_PointOfContact_dblClick(Cancel as Integer)

        Docmd.Openform "frm_People", , , "[POC_ID] = " & me.cbo_PointOfContact, , acdialog

    End Sub

    LVL 18

    Accepted Solution

    Macro attached to doubl-click on protocol number.   You can add Control Tip text to let the user know about the option.

    Author Comment

    Hi DoDah, I downloaded your DB and Im getting this error on every record I try
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    The problem with double clicking on any control that has text ... is ... the Windows standard is to select that text. So, any other operation is non-standard for double clicking.  Trust me ... users *expect* double clicking to select text.

    I use Shift+Double Click or Control+Double Click to do special things.  And the Status bar text and/or Control Tip text will indicate such.


    Author Comment

    What am i suppose to do to make this work

    Author Closing Comment

    I solved the problem

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Suggested Solutions

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now