Combo box - Bound column: 1, search column: 2

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

Guest

Hello,

I have a combo box with data from a chart of accounts.

The first (bound) column is the account number. The second column is the description.

I want to use account number in further computation. However when I search for an account number, I want to search the description since it is more meaningful.

Is there a way to have a combo box with bound column = 1 whereas column 2 is the one to search for?

Thanks
Kamil
 
If you have a one-to-one relationship between account
number and description then you already have that
functionality within the combo box. Go into the properties
of the combo box and click on the Row Source, then the
ellipse. You should see a query that has the two fields in
it. Have the query sort by Description rather than by
Account Number. When the user selects something in the
combo box the Account Number will be stored in the field
even though the records are sorted by Description. If you
don't want the user to even see the account numbers, set
the width of the first coulmn in the combo box to 0".
-----Original Message-----
Hello,

I have a combo box with data from a chart of accounts.

The first (bound) column is the account number. The
Click to expand...
second column is the description.
I want to use account number in further computation.
Click to expand...
However when I search for an account number, I want to
search the description since it is more meaningful.
Is there a way to have a combo box with bound column = 1
Click to expand...
whereas column 2 is the one to search for?
 
Back
Top