Disable Double-Clicking in Listbox

[TheStriker]

Hello All,

I have a listbox that I would like to prohibit users from double-clicking on a selection. The reason is because it duplicates the selected record, which is not the result I want. This is strange because I have no code in the 'OnDblClick' Event. Do you know of any tips or tricks to disable or block double-clicking on the listbox. Any suggestions or advice would be appreciated...Thanks in advance

TheStriker

 

[DJN]

I have tried to duplicate the problem, but I can't. I suggest you put some code in the On double click event procedure warning the user of the problem. Does it actually add another record or just to the list in the list box?

 

[Mile-O]

Do you have code in the Click event and maybe the double click is actually two clicks? If so, what does this code do?

 

[TheStriker]

Thanks for the response guys,

DJN: It actually adds a duplicate record into the underlying table.

Mile-O-Phile: I don't have any code in the OnDblClick Event or the Click event, that is what makes it so strange. The only code I have is in the AfterUpdate Event. Here is the code I have:

Forms![New]![Comments_WSReplacement subform].Form![txtSiteID].Value = Me.WSRList.Column(0)
Forms![New]![Comments_WSReplacement subform].Form![txtComment].Value = Me.WSRList.Column(10)
Forms![New]![Comments_WSReplacement subform].Form![cboContactTypeID].Value = Me.WSRList.Column(4)
Forms![New]![Comments_WSReplacement subform].Form![cboActionTypeID].Value = Me.WSRList.Column(8)
Forms![New]![Comments_WSReplacement subform].Form![cboIssueTypeID].Value = Me.WSRList.Column(6)
Forms![New]![Comments_WSReplacement subform].Form![txtdtCreatedON].Value = Me.WSRList.Column(1)
Forms![New]![Comments_WSReplacement subform].Form![txtUserID].Value = Me.WSRList.Column(2)

This code was given to me from this board by WayneRyan
When the user double-clicks a selection, it simply duplicates that selected record into the underlying table. Any ideas...?