fields in combo box

[Guest]

I created a combo box in a form that shows records with 2 fields but when I
choose the record, only 1 field is chosen to fill the box. What am I
missing to choose the record and have both fields fill the box so when I
print it, all info is there?

 

[Guest]

When doing a combo box dropdown, you can see multiple columns of data.
However you can only see one column after choosing a record as you've found
out. One solution is to put a second unbound text box on the form and use the
DLookup function to populate it based on the combo box choice.

 

[Guest]

Hi

Your combo will display the 1st combo column with a width set greater than
0cm. So if you have column widths of 0cm;0cm;1cm;4cm the combo will display
the 1cm column after update. To display another column create an unbound
text box and set the source as the column of the combo. In the example I
gave if you wanted to display the 4cm column the source for the text box
would be
=[ComboName].column(3)

Don't forget the combo columns start from 0 (so the forth column is column
number 3)

Hope this helps