Using the Selected property on a List Box

[IfButOnly]

I have a form with two List boxes. On selecting an item in one List Box, I execute a query and fill the contents of the second list box. This all works fine.

What I want is that when I click on List1, List2 is filled and the first item of List2 is selected automatically and highlighted.

I have been using 'Me!List2.selected(0) = true' from the Click event of List1 and while it does what I want, I get very strange effects whenever I use the '.Selected', including DB corruption.

Any ideas? Thanks

 

[GJT]

I have never experienced this - I would try reinstalling Access to ensure you have not got a set of corrupted VBA libs. on your HD.

I have not experienced this before - you seem to be using this property correctly.......