Combo Box

[Guest]

I have a table with repeated values in a column, I'd prefer not to split the
tables as updating and adding records would become a hassle in this
particular case.
Is there a way to prevent multiple appearances in a combo box?
Example.
Compound Rubber Type
#1 EPDM
#2 SBR
#3 EPDM

In a combo box that will present the "Rubber Type" column exactly as shown
above, since each compound is a primary key the combo box (i think) is
displaying the Rubber Type corresponding to the primary key. With a Text box
I can search exactly "SBR" and it will query all records that have "SBR". Is
there a way to do this with a Combo box?

Thanks

 

[Guest]

Hi Chris -- Of course there's a way. This is what you do.

Create a Query based on the table that contains the information you want.
Drag down just the field you want displayed in your Combo Box.
Utilize Access' Group By feature (File Menu | View | Totals).
Save and close your query.
Open the properties of your Combo Box.
In the Data Tab, where it says Row Type, ensure it says Tables/Query.
In the Row Source, select the Query you just created.

If you want these to appear in alphabetical order you can do that also from
the query. You can also weed out certain choices if you like. Hope that
helps. Good Luck.

 

[Guest]

Thank you Very very much, that changes a bunch of things for me.

Chris