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
Microsoft Office VBA, MS Access 2003, 2007, 2010, 2013, 2016