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?
Pulling certain names from a query to populate a list box (1 Viewer)
- Thread starter kloot1rr
- Start date
- Local time
- Today, 09:08
- Joined
- Jul 9, 2003
- Messages
- 16,280
You can have the listbox show the results from a query so I think your question should be more along the lines of how to generate that query.
- Local time
- Today, 09:08
- Joined
- Jul 9, 2003
- Messages
- 16,280
Ah! I see... From your title you mention a query.
When you say you only want to see the ones who have inventory, explain this in terms of your tables.
When you say you only want to see the ones who have inventory, explain this in terms of your tables.
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.
Attachments
-
54.png -
55.png
