Query the Display Value of a Combo Box Control Access 2000

  • Thread starter Thread starter Mike Thomas
  • Start date Start date
M

Mike Thomas

In Access 2000, I have a situation where I would like to query the display
value of a combo box.

This is a typical combo box where the bound column (col 1) is the primary
key of the table from which the display value is selected. The display
column (col 2) displays the values from which the user selects one.

So ? me.cbo.value returns the primary key of the selected row.

How can I return the display value?

Many thanks
Mike Thomas
 
Me.cbo.Column(1) (and Me.cbo.Column(0) is another way to return the value
from the first column)
 
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

Need combo box to refresh when moving to new record 2017 1
Combo box returning wrong value 2
Combo Box On Click 6
Update Combo Box 4
Combo box question 3
Using combo box when adding records to continuous form 1
Retain combo box order 1
Combo box supporting active/inactive choices 9

Back
Top