Combo box showing extra data

[kelsita_05]

Hi everyone-
I am working on a new form (frmFeedback), and I have a combo box that draws from a query. The query has one field, which is an expression
=Forms![Q and D]![LS Number].
It seems to be working well, but for some reason when you click the drop down, about 17 of the same LS number show up.
I only have one instance of the form Q and D open, and there is only one field LS Number. It picks the correct number, it just lists it many extra times.
Why is this happening?

Now, it may very well be that you can accomplish what I want to without all the needless drama.
I want the value in the LS Number field on the Q & D form to automatically show up on the Feedback form. But, I want that to record in the underlying table (Feedback), which I knew I could accomplish using a combo box that drew from the LS Number field on the Q & D form.

Is there a cleaner way to do this?
Thanks to all!

p.s. I'm running Access 2003 on XP. I have the John Viescas "Running Microsoft Access 2000" at my disposal.

 

[Moniker]

Have you considered SELECT DISTINCT as the record source for the combobox?

 

[Wiz47]

Have you considered SELECT DISTINCT as the record source for the combobox?

Moniker has hit it on the head. When you select from the rowsource it will return EVERY instance of that source unless you tell it to include only DISTINCT entries.

 

[kelsita_05]

Beautiful! That's exactly what I was looking for.
Thanks much!