fields in combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tjhoward - 14 Jun 2007 15:35 GMT

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?

Reply to this Message

Jerry Whittle - 14 Jun 2007 15:46 GMT

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.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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?

Reply to this Message

Wayne-I-M - 14 Jun 2007 15:51 GMT

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

Signature

Wayne
Manchester, England.

Reply to this Message