I have an interesting request from a user, but I don't see how to
implement the request.
When populating a combox with employee names, the user wants to see
first & last names which match any text being typed in.
Example, if the user types in "LA", the drop down box would include:
"Larry Johnson"
"Larimy Smith"
"Lansdown, Phil"
"Lany, Tom"

I feel like I will need to create a table with 2 entries for each
name. The first entry would be [First] & " " & [Last], and the second
entry [Last] & ", " & [First]. The problem is keeping the table
current with any name changes without rebuilding the table every time
there is a name change.

Any thoughts would be greatly appreciated.
THANKS!
David G.