Combo box based on multiple fields

[Guest]

I have a combo box based on 3 fields, CandidateID FirstName LastName. When
you click on the list it shows you FirstName LastName which is what I
wanted. When you click on a name though it only displays the First in the
box. In addition if you want to add/find someone say John Doe it will only
find someone if you only type John. If you type in John Doe it doesn't find
anyone. Anyone know what I am missing?

Ryan

 

[Allen Browne]

Try setting the RowSource of your combo to something like this:
SELECT CandidateID,
Trim(FirstName & " " & LastName) AS FullName
FROM tblCandicate ORDER BY FirstName, LastName;

Then set these properties:
Column Count: 2
Colum Widths: 0