How to populate the value of a Text Box based on the value in a Combo Box in MS Access 2007?

forms ms-access combobox ms-access-2007
CodingInCircles picture CodingInCircles · Jun 21, 2011 · Viewed 79.5k times · Source

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 Select 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!

Answer

Patrick Honorez picture Patrick Honorez · Jun 21, 2011

Make the source of the combo box to your 2 fields e.g. SELECT id, name FROM Customers
Make sure you set the Column Count property of the combo to 2, accordingly.
Then make you unbound text box source equal to =MyCombo.Column(1) (from memory, this Column is zero based).
That's it, zero code required.

Related questions

Add "All" option to ComboBox used to filter for report in MS Access

I'm trying to follow Microsoft's example on how to add an "All" option to a ComboBox in Microsoft Access, but their article does not do an adequate job of providing guidance, aside from specifying the code. What I'm trying to …

Read More
Adding a file browser button to a MS Access form

I'd like to add a "Browse" button to an MS Access 2007 form that will bring up a standard Windows file browser (as a modal window) and allow the user to select a directory. When the user OKs out of that …

Read More
MS Access Form - Enter key not moving to new line

I have an odd issue with a form I have in MS Access. For some reason, when I hit the "enter" key within a text box, the cursor moves to a different text box. What i am looking to happen …

Read More