troubleshooting Question

working with multi-value combo box

Avatar of Danny Reader
Danny ReaderFlag for United States of America asked on
Microsoft Access
8 Comments2 Solutions82 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros