Link to home
Start Free TrialLog in
Avatar of Chrisjack001
Chrisjack001Flag for United States of America

asked on

Double Clicking in a field

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 .
Invoice-7-7-2001-91611.accdb
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

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

JeffCoachman
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



ASKER CERTIFIED SOLUTION
Avatar of Richard Daneke
Richard Daneke
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Chrisjack001

ASKER

Hi DoDah, I downloaded your DB and Im getting this error on every record I try
Error.JPG
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.

mx
What am i suppose to do to make this work
I solved the problem