Return current value from a combobox

[Joakim N]

I have an active form MenuF on the screen. The form has a combox cboCluster. Is it possible to check what value actually returning from the combobox? Becasue I have following criterion in a query:



[forms]![MenuF]![cboCluster]

and the query doesn't return what I ecpected. I believe I misinterpret what value actually coming from the combobox.

In VBA Excel it's possible to use Debug.Print or a MsgBox. I don't know how to do that in Access.

[pbaldy]

Try this in the VBA Immediate window:

?[forms]![MenuF]![cboCluster]

it should be the value in the bound column.

[Joakim N]

Great. That worked fine.

One sub question. If I select an item (Actually a text string) in the list to my combobox, typing "?[forms]![MenuF]![cboCluster]" returns always 1 independent what I have selected in list to the combobox. That is creating my error. I want to return the text string in the combox. Any idea how I can get that instead of number 1?

[pbaldy]

Try

[forms]![MenuF]![cboCluster].column(1)

presuming you you want the second column.

[Joakim N]

Thank you!

That helped me a lot. Now I could actually use .Column(0) and and change slghtly in the macro code to a commandbutton.

[pbaldy]

Happy to help!