[Last Call] Learn how to a build a cloud-first strategyRegister Now


Combine Duplicate Fields in Combo Box

Posted on 2012-08-18
Medium Priority
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

IrogSinta earned 2000 total points
ID: 38308141
Is this what you had in mind?
LVL 31

Expert Comment

ID: 38308964
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

ID: 38310407
Thank you

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

830 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