Simple Table Question

[anoob]

I think this is probably a very simple question, but please bear with me. I have a table with a field called "Vendor". I need to retain the ability to add vendors to this field by typing them in, but I would also like a drop down box that shows previously entered values from this same field, to promote uniformity.



I have something somewhat working, but there are also several blank "selections" and the vendors in more than one record show up multiple times in the list.

Any idea what I am missing?

I suppose I could reference a table with one record that just has vendors, but that seems excessive for such a simple task...

Thanks very much.

[pbaldy]

The "standard" method would have a Vendors table with info about each vendor, and you'd use a combo box that got its selections from that table. You'd add new vendors using the Not in List event of the combo.

You can use your current method if you want. You'd use a combo with a row source like:

SELECT VendorName
FROM MainTable
WHERE Len(VendorName & "") > 0
GROUP BY VendorName
ORDER BY VendorName

Which should show one instance of each vendor, with no blanks.

[anoob]

AH, these both work well. Thanks very much!

[pbaldy]

Happy to help!