Combine Duplicate Fields in Combo Box

Posted on 2012-08-18
Last Modified: 2012-08-19
I have a form that looks up a record by part number. I have the combo box to where it is set up as a filter. So, when one of the part numbers is selected, all of the part numbers are shown.

What I am trying to do is only show one of the part numbers instead of multiple part numbers.

Attached is a copy of the database

If you have any questions, feel free to ask
Question by:jleval
    LVL 29

    Accepted Solution

    Is this what you had in mind?
    LVL 30

    Expert Comment

    Sorry, can't download that size of dba, neither the comment provided.

    You need to group By partNumber in the row source of the combo.

    Author Closing Comment

    Thank you

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now