How do I search on one value and store another in a Combo Box

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

Guest

Hi there,

I have a Combo box based on a table with 3 columns:
BillElement; LineItemDesc; LineItem

I want to be able to type in LineItem to search on in the Combo Box as this
is the format that the users are given - but I need to store the BillElement
field.

I tried hiding putting the bill element in the first column in the row
source query and hiding it (bound column set to 1) but this didn't work and
I'm a bit stuck - could anybody help?
 
You absolutely have the right idea! Assuming you have a 3-inch wide
description and one inch will be big enough to show the LineItem number (for
a total of 4 inches for the whole combo box), set the column width
properties as follows: 0";3";1"

The first column (BillElement) will not show because it's column width (in
the combo box) is zero!

Bob.
 
Thanks for your help Bob,

I tried this - Ithink something is wrong though because the value that is
being stored in the control is still the incorrect LineItem one instead of
Billing Element,
This is in a subform datasheet, is this affecting it do you think?
Also my combo box is bound - should it be unbound, and how do I get the
value into the control if so?

Thanks again for your advice
--
Kind Regards

Hazel


Bob Howard said:
You absolutely have the right idea! Assuming you have a 3-inch wide
description and one inch will be big enough to show the LineItem number (for
a total of 4 inches for the whole combo box), set the column width
properties as follows: 0";3";1"

The first column (BillElement) will not show because it's column width (in
the combo box) is zero!

Bob.
Click to expand...
 
Aha! - I got this to work, it was because I had a bound combo box, I changed
to unbound - thanks again!
--
Kind Regards

Hazel


huzzlepuzzle said:
Thanks for your help Bob,

I tried this - Ithink something is wrong though because the value that is
being stored in the control is still the incorrect LineItem one instead of
Billing Element,
This is in a subform datasheet, is this affecting it do you think?
Also my combo box is bound - should it be unbound, and how do I get the
value into the control if so?

Thanks again for your advice
Click to expand...
 
Back
Top