<%dim crumb crumb="Double Click Event" crumb1="VBA Double Click" %> DblClick Event
Home   Fees/Services   Access Templates   Tutorials  Tutorial Downloads   Articles   Search   Contact  Privacy  Links
<% response.write crumb2 %>
<% response.write crumb1 %>
 Home > Microsoft Access Tutorial > Form Event Tutorials <% response.write "> " & crumb %>

Access Event Tutorials:
Before Insert Event
After Insert Event
After Update Event
Before Update Event
Change Event
Close Event
Current Event
Double Click Event
Error Event
Exit Event
VBA Timer Event
Undo Event

Table-Level Events

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

Contact Information

<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>