• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

Access List Box - single click event firing only on double-click

OK - hopefully this is easy - I have code in the Click (not double-click) event of a list box in Access (2007). It is only firing when user double-clicks an item. This causes confusion, since if you click once, you select a different item, and then the displayed information is out of sync. Thanks!
1 Solution
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Not quite seeing how that could happen  ... Can you post the code you have in the click event?

Swapnil NirmalCommented:
please post sample access with code

Have you ever had any code behind the double-click event? I have sometimes had trouble with Access not 'registering' my code changes if I've made changes in the module rather than via the events list of the properties box.

But we still need to see some code!

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Mike EghtebasDatabase and Application DeveloperCommented:
First thing before any code add the following lines in there respective events and test them to see if click event works for the list box:

MsgBox "You clciked."

MsgBox "You dbl-clicked"
terpsichoreAuthor Commented:
I am not at my laptop - but wanted to reply. As a matter of fact this code was until recently in the double click event and I moved it to the click event...
Aha - I thought that was likely. Can I suggest you copy the code out, then delete the click and double-click events from code, and go to the properties window for the listbox. Then double-click  'on click' in the event tab, select event procedure and add the code back in there.

I hope that might help...
terpsichoreAuthor Commented:
Your initial comment led me to suspect there was some corruption - I decompiled and recompiled, and the problem (along with a few other small things) was solved. Thanks to you and the other respondents for great ideas.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now