Lookup field in a form.

[Mike]

To expand what I am trying to do...
the combo box in the form is required to show when
selected 4 field values ie G|JONES|A|01329 123456
When I select a name I only get the first part ie 'G' .
I suppose my question is in a FORM will I be able to
select and then have all four fields show..
These value are from a table which I have used in table
design using LOOKUP. as I said the values show when
incorporated in the form but only the first value stays
visable..don't know how to explain it further..

 

[Duane Hookom]

Your combo box is bound to only one field/value. You can concatenate several
fields together by altering the Row Source property of the combo box like:
SELECT PrimaryKeyField, FirstName & " " & LastName & " " & PhoneNumber
FROM tblCustomers
ORDER BY FirstName & " " & LastName & " " & PhoneNumber;
Set the bound column to one but set the column widths to:
0",2"
This will hide the first column and display "Mike Jones (555) 555-1234"