Combo box h3llz 12/4/2008 12:17:12 PM Ive got a combo box which got two columns, staffID and staff name, the first column is 0cm and second is 2cm, how can i get the first column value via vb?

Re: Combo box Rick Brandt <rickbrandt2[ at ]hotmail.com> 12/4/2008 12:29:50 PM On Thu, 04 Dec 2008 04:17:12 -0800, h3llz wrote: [Quoted Text] > Ive got a combo box which got two columns, staffID and staff name, the > first column is 0cm and second is 2cm, how can i get the first column > value via vb? The bound column (regardless of its position or column width) is simply... Me.ComboBoxName Any column besides the bound column is... Me.ComboBoxName.Column(0) Me.ComboBoxName.Column(1) etc.. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com

Re: Combo box h3llz 12/4/2008 3:16:19 PM thanks "Rick Brandt" wrote: [Quoted Text] > On Thu, 04 Dec 2008 04:17:12 -0800, h3llz wrote: > > > Ive got a combo box which got two columns, staffID and staff name, the > > first column is 0cm and second is 2cm, how can i get the first column > > value via vb? > > The bound column (regardless of its position or column width) is simply... > > Me.ComboBoxName > > Any column besides the bound column is... > > Me.ComboBoxName.Column(0) > Me.ComboBoxName.Column(1) > etc.. > > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com >