Lookup Field in a form with multiple fields

[Mike]

I have set up a lookup in a form using a combo box all
seems ok except that it will only show 1 (one)of the 4
field I want to show in the form, I have tried all sorts
of combinations but I just get this 1 field

 

[Rick Brandt]

I have set up a lookup in a form using a combo box all
seems ok except that it will only show 1 (one)of the 4
field I want to show in the form, I have tried all sorts
of combinations but I just get this 1 field

Do you mean when the list is "dropped" or after you have made a selection?

If the latter, you need to know that a ComboBox will only display the left-most
column of non-zero width when not dropped down. There is no way to make it
display more than that. You can make that particular column an expression that
concatenates multiple columns together. You can also add other TextBoxes to
your form for the purpose of displaying the other columns using...

=ComboBoxName.Column(n)

....as the ControlSource where n is the zero-based column position in the Combo's
RowSource.

If the former, then you need to make sure that all of the columns are included
in the ComboBox's RowSource and that the ColumnCount of the ComboBox is set to
display the proper number of columns and that the ColumnWidths property is set
to make sure that columns you want to see have a width higher than zero.

 

[Jeff Boyce]

Mike

First, you posted this in the "tablesdbdesign" group, dedicated to issues
related to table design, not forms.
Second, you have described a combo box that displays only one field -- but
not provided the SQL on which the combo box is based.

Third, you've also not described the number of columns (a property) your
combo box is set to display, nor the column widths.

Finally, you've "tried all sorts of combinations" but haven't described
any -- are you asking us to re-try all the same ones you have? If so,
please let us know which ones we should (?should not) re-try.

More info, please...

Jeff Boyce
<Access MVP>