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?