I have gone over the material on Combo Box a number of times and really see its value, especially for data entry, eg, when adding a new contact. However, if we look at Video 5 @ 2:17 we see ContactID=1, Customer=Pharmacon and Notes starting out “Richard called..” This contact is actually Richard’s in our example and therefore customer 1, Amicron. How do we preserve data integrity when we can scroll the customer combo box and leave it as a different customer, thus inadvertently loosing the link between the true customer and this contact? Thanks for great courses! Bonnie

---

Reply from Richard Rost:

You bring up a very good point. Yes, at this point you can change the customer by editing the combo box. You can LOCK the combo box (one of its properties) to prevent the user from doing this, OR you could create a SUBFORM for the contacts (which is what I actually prefer). In this case, locking the combo box would provide the quickest solution.