Modules & VBA :: Display Multivalues Horizontally

Let's say I have:

Customer Table - CustID
Product Table - ProdID
CustomerProducts - Contains the CustID and ProdID

I have an "input" form with Customer Name, Address, etc and a subform that allow selecting his/her products.

I want to DISPLAY (only display), in another subform, on this form, (not a report), every customer that has a product in common (even if just one) with the main form customer. Also need it laidout this way:

For example, if Joe Robins has the following products selected: celery, lettuce, tomatoes. The following customers would appear in that subform - because they have ONE or MORE products in common with him:

John Doe (carrots, celery, potatoes)
Mike Smith (carrots, radish, tomatoes)

but this customer would not show up:

Mary Lamb (potatoes, cauliflower)