Here is the code to open the form with a double click:
Private Sub CID_DblClick(Cancel As Integer)
On Error GoTo Err_CID_DblClick
DoCmd.OpenForm "CUSTOMER", , , , , acDialog, "GotoNew"
Me![CID].Requery
Exit_CID_DblClick:
Exit Sub
Err_CID_DblClick:
MsgBox...