Transfer List Box Selection to Another Form

[Michael J Ross]

If I have a form that has a list box of several columns, how do I go about setting a value of a text box in another form to one of the columns in the list box when a user double clicks on the appropriate row?

I should say that the value of the text box in the form I want to transfer the record to won't always come from the list box, as the list box is used to list query results if the user is unsure of what to enter in the text box.

I've attached a screenshot of my forms, what I want is to double click the selected record and move column2 of the list box to Vendor Id on the main form.

Thanks