Selecting Combobox Default in VBA (1 Viewer)

[SeanDelere]

I am sure this is simple but I just can't seem to find the way to do it.

All I want to do is select a value in a combobox from the onclick event of a button.

So far I have tried

comboname.defaultvalue = "GE"
comboname.value = "GE"
comboname.text ="GE"

All without any success

Any ideas?

 

[dcx693]

The one that should work is comboname.value = "GE", but you can drop the .value property since that's the default. If that's not working, then I would guess that the combo box has multiple columns and "GE" is not the proper form of the bound column.

 

[SeanDelere]

Thats what I though too.

I have worked round the problem using a DBLookup as the combobox default value.

Thanks for the help.