DblClick Event


Access DblClick Event Example

VBA Form On DblClick Event Examples – Code Samples

On DblClick event occurs in VBA when the user presses and releases the left mouse button twice within the double-click time limit of the computer.

Double Click Visual Basic Example:

We often use the DblClick event to display detail records attached to a master record.  Here we display the F_Order_Details from when the user clicks on a record in the main order details form:

Private Sub Order_Number_DblClick(Cancel As Integer)
DoCmd.OpenForm “F_Order_Details”, , , _
“Order_ID = Me.Order_ID”
End Sub

The event order for clickable controls other than buttons is:

MouseDown → MouseUp → Click → DblClick

Programming for the double click event is the same as programming for the single click event.  Note that novice computer users have difficulty double clicking.  Others always double click on items since it is the standard way of activating objects in the Windows environment.

When you have objects with only a single click event you might want to consider calling the single click event from the double click event to help reduce user frustration.

Form Triggers
Table Triggers
Form Flags
Table Triggers
Record Flags
Record Events

Microsoft Office:
MS Access 2003
Access 2007
Access 2010
Access 2013
Access 2016

Open Email Using SendObject Access Download User Inactivity Logout VBA Code Disable Shift Key Demo Send Email Microsoft Access Tutorial Download (Advanced) Sequential Counter in Query Multi Select List Box Query Parameters Row Level Data Security Programming MS AccessSecurity Alternative Single User Inventory Calculations Download How To PerformMulti-User Inventory Calculations Make Dependent Combo Box Code MS Access Tutorial Union Query Example (Simple) Union Query (Advanced) Access Tutorial How ToFill Fields From Combo Box Use Global Variables as Parameters Continuous Form Dependent Combo Box How To Program Continuous-Continuous Master/Detail Forms Access Bar Chart / Bar Graph Programming Crosstab Query Example TransferText & OutputTo Microsoft Access DoCmd.OpenForm & OpenArgs VBA Example Running Sum Query Method Choose Command Dynamic SQL Order By Access Conditional Format Access Report Banding

Popup Form Control Method

Microsoft Office VBA, MS Access 2003, 2007, 2010, 2013, 2016