Exporting combo box data to separate field in form

[stanley721]

O.K. I've seen similar posts on this but just couldn't get the exact scenario that I am looking for. I have a form with a 2 column combo box that displays a list of form numbers and then the name of the form. Then there is another field in the form that is supposed to take what gets selected in the combo box and placed that data in the field. I want both the form number and the form description to show up in that next field. Right now, it will only show the description. Then I want that data to go into a table, but that isn't the main issue. I'm getting tht but want both to be placed in the table as one long string. Any ideas?

[alansidman]

Look here. Try using this approach and in the target text box, join the two columns with an ampersand (concatenation)

[stanley721]

Where does that go? I have the control source as the table field I want the data to be placed in.

[Missinglinq]

...Look here...

Look where?

But alansidman's talking about something like this:

Private Sub YourComboBox_AfterUpdate()
  Me.TargetField =  Me.YourComboBox.Column(0) & " " & Me.YourComboBox.Column(1)
End Sub

assuming that the form number and form description ar the first two columns in the Combobox, starting at the left.

Linq ;0)>

[stanley721]

That didn't do it. It gave me some error. Wouldn't that lock me into having to use what was selected from the combo box? I want the option that a person can select what shows up in the Combo Box or just go to the field and type in what they want. Then I want that data, no matter how it got there, to be placed in that field in the table. Is that possible? Seems like it should be.

[alansidman]

Linq;

Thanks, that is exactly what I was proposing. BTW, the link I forgot to post is

http://www.baldyweb.com/Autofill.htm