In the attached database, I'm using multi-value combo boxes to track employees (see tbl_Accounts). I'd like the multiple names to appear with last name, first name and separated by a colon (Smith, Joe; Barry, Sam; Sweeny, Sue). But instead it just shows last name.
And in my frm_SearchMulti form employees are showing with their ID number instead of name, and I'm getting duplicate rows.
How can I control what appears for these multi-value fields? CC_Sample.accdb
(I also had to change the "system Separator" property to a semi-colon ( ;)