I have 2 tables, Training and Trainer related by TrainerCode(N3). The Trainer table contains Trainercode, Lname, Fname and Company. I have a ComboBox on my form that shows Lname, Fname and Company as its choices. The ComboBox's .InteractiveChange code REPLACEs the TrainerCode in Training and updates the .Value properties of several textboxes.

When stepping through the records of Training I update the .Value properties of the textboxes and Refresh the form. How do I get the value of Lname to show up in the ComboBox's .Value when it's read only?