Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Double Clicking in a field

Posted on 2011-10-06
Medium Priority
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
ID: 36927541
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 49

Expert Comment

by:Dale Fye
ID: 36927634
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 19

Accepted Solution

Richard Daneke earned 2000 total points
ID: 36927660
Macro attached to doubl-click on protocol number.   You can add Control Tip text to let the user know about the option.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 36927705
Hi DoDah, I downloaded your DB and Im getting this error on every record I try
LVL 75
ID: 36929011
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

ID: 36930980
What am i suppose to do to make this work

Author Closing Comment

ID: 36933198
I solved the problem

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

581 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