Form-Subform Design Revisited and populating text boxes

OK, can someone please help me out here? I feel that once this issue gets solved for me I'll be able to proceed pretty quickly. I have attached a very simple database as an example.



A few questions:

1. Is my design "correct"?
2. In a subform, I want to populate a text box with a combo box value. As it stands now, there are 2 things I am doing simultaneously in testing this. I am making the combo box the Control Source for the text box. However, the "Column" part does not pop up when I build the expression and it gives me an error when I put it there. Anyway, this works to a point - the text box is populated with the first column of the combo box, but that's it. I want the 3rd column.
3. Also, I put in an AfterUpdate event procedure Me.TextBox = Me.ComboBox.Column(2). This does not impact the results unless I change the Control Source for the text box to something else, or make it unbound. I used to get an error (related to ActiveX Controls) but now nothing happens. The combo box is fine but the text box is blank.

Anyway, I think I'm close. Have a look at my setup and let me know what the issue(s) are.

Thanks!

load your sample.
Attached is an example I posted for another user several days ago.
Although the example uses listboxes, I believe the code would be essentially the same for comboboxes. I did this example to illustrate a way for forms and subforms to interact, not really for working with listboxes. Nevertheless, it may help straighten out your referencing (perhaps using the wrong bound column?).
Open Frm1, then make a choice from one of the listboxes. The text box is populated. The left list box uses Column 1 and the right list box uses Column 2, determined by the bound column property. I hope this helps.