Lookup field in a form.

  • Thread starter Thread starter Mike
  • Start date Start date
M

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..
 
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"
 
Back
Top