column collection

  • Thread starter Thread starter smk23
  • Start date Start date
S

smk23

Is there a way to designate the name of a column rather than the index
position on a combobox column, i.e.

Me.cboMybox.Column("columnName")

rather than

Me.cboMybox.Column(2)

Thanks!!
Sam
 
smk23 said:
Is there a way to designate the name of a column rather than the index
position on a combobox column, i.e.

Me.cboMybox.Column("columnName")

rather than

Me.cboMybox.Column(2)
Click to expand...


There is no built-in capability for that.

In a VBA standard module, you could declare variables or
constants with the column numbers:
Public Const MyName As Integer =2

Then any VBA module could use:
Me.cboMybox.Column(MyName)

but that will not carry over into control source
expressions.
 
Back
Top