Can I have a Combo Box without a Control Source?

[David Ball]

Hi,

I want to have a Combo Box on a form, that derives its values from a Table, but does not send selected values to another table. I want to use the value selected in the combo box in VBA code.
I have set up a combo box, without a control source, and it shows the values in the drop down list but after I select one the box just goes empty. I expected that after selecting a value that value would be displayed in the combo box (and that would then become the “value” of the combo box that I could then use in code. I.e, CmdBox1.Value).
Can I use a combo box in this way?
If so, what do I need to do so that the value selected is displayed (and becomes the value of the combo box?)
Thanks very much

Dave

 

[CJ_London]

Can I use a combo box in this way?

Yes - it is a common way to use it

If so, what do I need to do so that the value selected is displayed (and becomes the value of the combo box?)

You need to make sure you have set your column count, bound column and column widths correctly. The bound column is the column which contains the value of the control.

 

[David Ball]

Thanks very much, CL_London