double-click detail behavior

  • Thread starter Thread starter Andy G
  • Start date Start date
A

Andy G

The double-click on the detail section only works on the first record of the
form. The rest of the records do not fire the event. If I make one of the
text boxes enables but locked then it seems to work. Any insight?

Settings:
- Continuous Forms
- Cycle all records
- All the text boxes in the detail are not enabled and locked
 
The double-click on the detail section only works on the first record of the
form. The rest of the records do not fire the event. If I make one of the
text boxes enables but locked then it seems to work. Any insight?

Settings:
- Continuous Forms
- Cycle all records
- All the text boxes in the detail are not enabled and locked
Click to expand...

Care to describe how you are detecting the doubleclick event, and
perhaps post your code?


John W. Vinson[MVP]
 
I am using the event DoubleClick, I'm not sure what you want me to describe
for detecting the doubleclick event.

The code is simply opening a form.
 
I am using the event DoubleClick, I'm not sure what you want me to describe
for detecting the doubleclick event.
Click to expand...

The doubleclick event of... what? The Form? the Detail section? a
control on the form?

Please copy and paste the actual VBA code that you're using.

John W. Vinson[MVP]
 
I'm sorry...it's a double click on the detail (which I stated in my original
post)

Private Sub Detail_DblClick(Cancel As Integer)
'Check user rights/roles
If Forms!frmGlobal!txtUserRole = 3 Then
MsgBox "Missing appropriate permissions to proceed." & vbCrLf &
vbCrLf & "Contact system administrator for further information.", vbOKOnly +
vbExclamation, Forms!frmGlobal!txtSysName & " Security"
Else
Forms!frmGlobal!chkDelNote = True
SetNoteID (Me.NoteID)
DoCmd.OpenForm "frmNote"
End If
End Sub

Sub SetNoteID(c$)
cNote$ = c$
End Sub
 
Back
Top