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:

 

[Uncle Gizmo]

What is the code of your command button?

 

[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.

 

[Uncle Gizmo]

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

I can't do A2010 pls save and post it as A2007


Regarding the uploaded database, you should reduce the records in your database to minimum. Make sure you have "compact on close" switch on and then also provide a database in *.zip file format.

 

[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!