>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?
Colin, the fact that your data is read only should make no difference in your combo box. It sounds like you have TrainerCode as your combobox value, but want to use LName as your displayvalue. Check which column is bound to the table, and remember that if you set a columnwidth to 0 it is invisible to the user.
HTH
Barbara