Hi,
I have two lists and three boxes with items. On the afterUpdate event of one list (list2) I have:
For i = 0 To lists1.ListCount
If list1.ItemData(i) = list2.Column(1) Then
list1.Selected(i) = True
Exit Sub
End If
Next i
That is, I go through each row of list1, compare it to the selected one in list2, and select it in list1.
The problem is that when I click on an item of list2, then I cannot moe to any other edit box in the form. Everytime I try to click on an edit box it will run the afterUpdate code of the list, and will not allow me to set the focus on a list.
Any idea?
Thanks,
Klasse
I have two lists and three boxes with items. On the afterUpdate event of one list (list2) I have:
For i = 0 To lists1.ListCount
If list1.ItemData(i) = list2.Column(1) Then
list1.Selected(i) = True
Exit Sub
End If
Next i
That is, I go through each row of list1, compare it to the selected one in list2, and select it in list1.
The problem is that when I click on an item of list2, then I cannot moe to any other edit box in the form. Everytime I try to click on an edit box it will run the afterUpdate code of the list, and will not allow me to set the focus on a list.
Any idea?
Thanks,
Klasse