Combo Box Situation - Filling Text Box Based on Selection

[LadyDev]

How can I pass the parameters of a single field (tblCombo/Lg_Desc)based on the selection from a combo box? The form is being used as a pop-up.

This is the situation. I have a form with a subform. The subform is being populated with a lot of stuff via (tblCombo). A selection from an option group populates the combo box and selection from combo box populates the data display. It's working okay, but the long description field is too long to see in the data grid(?) without scrolling right.

(1) I thought about using a text box, independent of the data grid, but how do I display just that single field, based on the criteria above...

(2) Using a hyperlink, but then I would have to create numerous forms, unless I could use a single form based on the criteria above...

(3) I ran out of ideas...

Can anyone help? Or maybe you have a different idea I could run with. Thanks!

 

[Rick39]

If you go with the text field (assuming your combobox fields are set up like Noun, Description), you could, in the AfterUpdate event of the combobox use:

Me!YourTextBox = Forms!YourForm!YourComboxName.Column(1)

 

[LadyDev]

Does this mean I will have to create forms for each combo selection. I not understanding the code.

Me!txtDescr = Forms!frmDocViewer!cmboChoice.Column(1)