troubleshooting Question

Combo Box to display ID's used only

Avatar of caseyu
caseyuFlag for United States of America asked on
Microsoft Access
8 Comments2 Solutions283 ViewsLast Modified:
I am trying to create a combo box that will only display the ID's that have been used on the master table. I have one table called customer type that gives a unique key and description for customer types. When the master table is populated with customers the users choose from a drop down list that is populated with the unique ID and description from the Customer Type table.

Now I am in the process of creating a multi-parameter query that will display customers based on what the user chooses from multiple combo boxes on a form. The challenge I am running into is there are some customer types that have not been used yet. I need that customer type combo box to only show the ones that have been used on the master table, not all of them from the Customer Type table.

I have searched and searched this board, in fact I have spent the last couple hours doing so, trying to find my answer and keep coming up empty. It is probably in how I am doing my search of the board, but I have tried several combinations of words and still cannot seem to find the answer. I know it is probably something simple but it is costing me a lot of time to find it.

Thanks,
ASKER CERTIFIED SOLUTION
gnetgnet

Our community of experts have been thoroughly vetted for their expertise and industry experience.

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