Copy a subform list box value to a form's combo box

[guamlet]

I have a form and subform. The for contains a combobox that, when a value is selected, will auto-fill the appropriate values in the subform. Also in the subform is a listbox that contains the last entry in a certain table. I would like to set a Double Click command that would transfer this value into the combobox. Please not that the value exists in the combobox, so it should be like typing the the string and having the combobox auto guess what you are typing, right? Any help?

Guamlet

 

[guamlet]

Problem Solved..

Me![Combo34]=lst42.Column(1,lst42.ListIndex)

This gives me the index for the value I want and Combo34 accepts it and converts it back to the string that the user understands.