Now I've made a list, that shows all the records in my table.
If I double click, I want the selected item in the list to be shown in textboxes.
I know I have to do this with a certain Index, but I can't get it right.
This is what I have now:
Private Sub Collst_DblClick() Dim myVariable myVariable = Collst.ListIndex Data1.Recordset.Move myVariable End Sub
The problem is, it seems as if it doens't get the index of the selected item, but just a random index.
I also get an error sometimes (not all the time, that's the weird thing) and it selects Data1.Recordset.Move myVariable
Can someone help me with this?
(edited because I forgot a bit)
This post has been edited by CSI-Fan3: 12 January 2009 - 11:34 AM