Help! Mouse Click can't work on OK button for Combo-Box selection

[lookingforK]

Hi Experts,

I get a bizarre situation while I am using MS Access 2010 to select values with Combo Boxes on a form, i.e.:
* After I select one or more values from the drop-down list of a Combo Box, there is no response when clicking OK button using the mouse. It is stalled. I need to do the process again and then the mouse-click on OK button could work: click anywhere outside of the combo box, re-select the values, click OK Button, and done.

* However, I can always use Enter key (on the keyboard) upon OK button to complete the selection.

* The values in the drop-down list of the Combo Box were entered manually.


What is wrong with the combo boxes on the form? Why do I need to do twice to complete the selection using mouse-click? Why the keyboard-click ('Enter') can be always OK but not for the mouse-click?


Thank you in adavance! :banghead:

 

[vbaInet]

I'm a bit confused by your explanation.What should the OK button actually do when clicked? And what is the relation to the combo box and the action the button takes?

Edit: I got here a bit late Uncle T.

 

[lookingforK]

What is the code of your command button?

Thank you Gizmo,

There is no code for OK button (that is for the Combo-box as attached example).

 

[lookingforK]

I'm a bit confused by your explanation.What should the OK button actually do when clicked? And what is the relation to the combo box and the action the button takes?

Edit: I got here a bit late Uncle T.

Thank you VbaInet.

Please check the above attached pic .
* The relation to the combo box and the action the button takes: when click OK button, values selected could be put in the combo-box; otherwise, no values are gonnna show up in the combo-box.

I guess this is a bug for MS Access 2010.

 

[vbaInet]

You're using a multi-valued field. Why don't you create a separate table instead and use a mutli-value listbox?

Anyway, upload a sample db so that we can test it out.

 

[lookingforK]

Hi all,

I found the solution.

The problem was caused by a new multi-valued combo-box I created on the form. I used "Format Painter" to copy an existing combo-box (that has a conditional formatting) to this new one.

After I removed the formatting from the new one, things become normal.

Thank you all!

Have a good one!

 

[vbaInet]

Good to hear!