Text box to populate from combobox

[Master Klick]

I have a combo box in a form with row source: SELECT Accounts.[Account Name] FROM Accounts ORDER BY Accounts.[Account Name];
This gives me a drop down list that contains my various accounts.

I have a text that needs to show the balance of the account selected in the combo box. I will also be adding the values of two other text boxes to this, but that I can figure out.

I just need help getting the text box to look up the balance of the selected account.

[June7]

This is already marked sovled. Is it?

[Master Klick]

This is already marked sovled. Is it?

Yeah, I figured it out. I was looking at the wrong thing. I ended up adding a column to the combo box and set the text box control source to the second column.