repeated fields in a combo box

[sentient_amoeba]

Hi there. I'm having a little trouble adjusting a combo box on my form. I'd appreciate any suggestions!

I'm using a combo box to find records on a continous form. I'm selecting a particular Kit to view all the components of the kit. So, for example, if I select "Kit A" from the combo box, my form will give me, say, three records:

Component A..... 5 grams
Component B..... 8 grams
Component C..... 2 grams


But! My combo box won't just display ONE "Kit A", it displays THREE (one for each record.)

How do I adjust my combo box (or maybe my table?) to show just ONE value with which to select my records, rather than repeating the same one over and over?

Thanks so much for any help!

 

[WayneRyan]

amoeba,

Use the Distinct in your SQL to select the kits.

Select Distinct(Kit)
From YourTable
Order by Kit;

Wayne