Guys,
only one question here.
I did manage to get textboxes populated however when i click on second item in listbox, the info of the frist record is still standing, how can i change this. i want as soon as i click on an item the data of that item shown in the textboxes. I cant send the file into the forum because its way to big now
Here the file in public box
This is in the form SearchResultForm
Private Sub ListBox1_Click()
With Me.ListBox1
On Error Resume Next
Me.AssetTextBox1.Value = .List(.ListCount - 1, 0)
Me.SerialTextBox1.Value = .List(.ListCount - 1, 1)
Me.EquipmentTextBox1.Value = .List(.ListCount - 1, 2)
Me.ManufactTextBox1.Value = .List(.ListCount - 1, 3)
Me.ModelTextBox1.Value = .List(.ListCount - 1, 4)
Me.LocationBox1.Value = .List(.ListCount - 1, 5)
Me.SubmitTextBox1.Value = .List(.ListCount - 1, 6)
Me.DateTextBox1.Value = .List(.ListCount - 1, 7)
End With
End Sub
If anyone can help me with this
Thanx in advance
Bookmarks