title: How to populate the value of a Text Box based on the value in a Combo Box in MS Access 2007?
body: <p>I have a combo box which is of a lookup type, i.e., I've selected the source to be a column from a table and am storing the selected value in another table. The table which I am looking up has another column and I need the value in this column to be displayed in a text box and each time I change the value in the combo box, I need the corresponding value to be displayed in the text box. How can I do this? What I have done so far is to write a <code>Select</code> query that selects the appropriate column based on the combo box's value. Is there a more decent way of doing this? Please help me!</p>