Choosing Combo Box Columns

E

Eli

Hi, I was wondering if there is any other way to refer to a column of a
combo box with anything other than the Column property?

I'd like to refer to columns by way of something similar to using "Fields"
in recordsets.

Instead of: me.txtCost.Value = me.cboItem.Column(2)

I'd like to do this: me.txtCost.Value = me.cboItem.Fields("Cost") (or
something like this)

I know I can't use Fields, but maybe there's something similar. If anyone
knows a way to do this, please let me know. I want to do this so that if
the order of the columns changes, my code won't break because it will use
the column by name instead of number, and then it won't matter if stuff gets
shifted around.

Thanks in advance for the help.
 
E

Eli

Good point.

I guess I'll just make sure I add any new columns to the combo box at the
end and not shift them around.

I also wanted to refer to them in code by name so it's more legible, but
I'll use comment lines for that.

Thanks.
 
Top