I have a combobox that drops down First Name and last name as seperate fields. I don't want to combined them like you did. I want the combo box to display the first name, which it does, and a seperate text box to display the last name. How would you do that.

---

Reply from Richard Rost:

You're SELECTING a customer on a form where CustomerID is a foreign key, correct? If so, just make two combo boxes next to each other. Have them both bound to CustomerID, but make the visible field the first name in one and the last name in the other. When you change one, it should change the other.