Re: Combo Box Description

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

bw wrote:
Please bear with me, as I'm not sure how to ask my question.

I have a combo box in a form that has the index, a value, and a
description. For example, one entry might look like this: 1, AP,
Accounts Payable.
In the same form, on the same value selected for the combo box, I
want to use another text field to access the Description of the combo
box.
For example, in my text field I have tried to access the description
in the combo box with the following for the source code:
=[cboBox].Column(3)
but this is obviously wrong because it gets saved as:
=[cboBox].[Column](3) and gives me the error: #Name?.

For those who understand my question, can you explain what I'm doing
wrong?

Your expression is fine except that the column numbering starts with zero so
the third column would be .column(2).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.