Chrisjack001
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
Invoice-7-7-2001-91611.accdb
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_dblClic k(Cancel as Integer)
Docmd.Openform "frm_People", , , "[POC_ID] = " & me.cbo_PointOfContact, , acdialog
End Sub
Private Sub cbo_PointOfContact_dblClic
Docmd.Openform "frm_People", , , "[POC_ID] = " & me.cbo_PointOfContact, , acdialog
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi DoDah, I downloaded your DB and Im getting this error on every record I try
Error.JPG
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
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
ASKER
What am i suppose to do to make this work
ASKER
I solved the problem
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