how can I make a combo box that takes more than one option, example, assuming that the customer was from PA - CA - NY etc  I know this is not possible but I am working in a project that I have to insert say about 10 items.

---

Reply from Richard Rost:

Edwin, this is something that is BEST done with a separate, related table and a subform. I cover this in the Expert series of classes. You COULD use a multi-select list box or a multi-valued field (which I also cover in different lessons) but the related table and subform is the BEST method.