how to drag a file name from a list box to text box 1

[Johnny0123]

hi,

Looking for a way to drag a file name from a list box to fill in a text box. It could be that a double click event that could sent it to the text box. Does not have to be dragged.

Thank you !!!!!

-John

 

[mishbaker]

Well, if the value of the ListBox is what you are wanting to send to the textbox on DblClick then:

Private Sub List0_DblClick(Cancel As Integer)
   text1.value = list0.value
End Sub

All lessons learned from the School of Hard Knocks........at least tuition is cheap.

 

[Johnny0123]

Thank you soooo much ! I am fairly new to the field (straight out of college).

if i wanted to make every time the user clicked the file in the listbox, it would be put into a new text box(text1). The text box(text1) is on a subform, and in datasheet view, so it would fill the next record.

Thank you again for all the help!!!

-John