Lookup fields

G

Guest

I have created a lookup field which looks up 2 fields forename and surname.
When viewed in the combo box on the form both values appear, however when a
selction has been made only the forename remains in the box.

I would like both names to remain if possible. Can anybody help me or lte
me know if its not possible.

Thanks Ian
 
J

JohnFol

Base the combo on a query, and concatenate the 2 fields in the query. The
combo will then display them as one
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate 4
Combo Box question. 3
Duplicate entries 3
matching data on two separate worksheets 1
List, Combo, or something else 5
Hiding scroll bar in combo box 7
Automatic Form Completion 6
Lookup on a subform 2

Top