Pulling certain names from a query to populate a list box

[kloot1rr]

I have a form set up (in a list box) to show our salespeople what parts they have yet to get out of inventory but have a sales order for. The list box shows a list of all the salespeoples names. My manager wants me to show ONLY the salespeople that have populated fields in this list box. The list box currently shows all the salespeople, but I want to see only the ones that have inventory that has yet to shipped. How do I go about this?

 

[JLCantara]

A screenshot of your DB relations would help. I may have a solution but I need to know your DB structure...

 

[kloot1rr]

Hey guys thanks for the replies. Pic 54 shows my query which all my data for the form comes from. Pic 55 shows the connection I have for my form to view the all the names. Hopefully this helps a little.