Link to home
Start Free TrialLog in
Avatar of terpsichore
terpsichore

asked on

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!
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Not quite seeing how that could happen  ... Can you post the code you have in the click event?

mx
please post sample access with code
Hi,

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!

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"
Avatar of terpsichore
terpsichore

ASKER

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...
ASKER CERTIFIED SOLUTION
Avatar of plummet
plummet
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.