ListBox Problem

[DS]

I have three listboxes on a form whenever I click o the first one,
related info comes up in the second, so on and so forth. The problem is
that whenever I click on the first one (or the second) the records come
up an the first one is always selected (Just appears that way, because
it returns no value). I tried this code thats below and it works fine
untill it runs a second time. then it locks up the next listbox and you
can't select nothing. So how can I select a record in the first listbox
without having a record selected automatically in the nex listbox?
Thanks
DS






Dim I As Integer

For I = 0 To Me.List40.ListCount - 1
Me.List40.Selected(I) = False
Next I

 

[DS]

I have three listboxes on a form whenever I click o the first one,
related info comes up in the second, so on and so forth. The problem is
that whenever I click on the first one (or the second) the records come
up an the first one is always selected (Just appears that way, because
it returns no value). I tried this code thats below and it works fine
untill it runs a second time. then it locks up the next listbox and you
can't select nothing. So how can I select a record in the first listbox
without having a record selected automatically in the nex listbox?
Thanks
DS






Dim I As Integer

For I = 0 To Me.List40.ListCount - 1
Me.List40.Selected(I) = False
Next I

Problem Fixed

Me.List40.Value = Null

Thanks
DS