Combobox-retrieving data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to get the value of the second column of a combobox (the first column is bound)
 
To display only the second column, on the combo box property sheet set the
column count to 2 and then in the column width box set the width of the
first column to zero.

--Wesley

Udi said:
i want to get the value of the second column of a combobox (the first
Click to expand...
column is bound)
 
Udi,

If this is in the controlsource of an unbound textbox on the form...
=[NameOfCombobox].[Column](1)

If it's within a VBA procedure...
Me.NameOfCombobox.Column(1)

- Steve Schapel, Microsoft Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2-colums Combobox , after selecting show one colum 4
Multi-column combobox only showing first column 1
Combobox bound column value? when width is 0cm 2
Update Text Box 3
combobox population record dependent 4
Multiple text boxes retrieving data from combobox source 1
Unbound Combobox 2
Combobox column not displaying although there is data 3

Back
Top