[AccessD] Weird List Box

Hey Rocky
Thanks
Next time this weird thing occurs I will try the ListCount, may just do 
the job.
Basically the ListBox2 is requeryed on AfterUpdate of ListBox1.
It is just that because this weird thing happens out of the blue, that 
it has me baffled as to why/what causes it???


rockysmolin at bchacc.com wrote:

>WAG - try the scroll trick:  
>
>In the open event of the form
>
>dim x as Variant
>x=Me.Listbox1.ListCount
>
>May not make a difference but it's a 30 second test.
>
>And how about requerying listbox 2 after the user makes a choice ?  Is
>making Listbox1 a combo box with an after update event where you could
>put the listbox 2 requery an option?
>
>
>Rocky
>
>-------- Original Message --------
>Subject: [AccessD] Weird List Box
>From: Tony Septav <iggy at nanaimo.ark.com>
>Date: Sun, March 13, 2011 8:20 am
>To: Access Developers discussion and problem solving
><accessd at databaseadvisors.com>
>
>Hey All
>I have a test form with 2 list boxes, select an item in ListBox1 and it 
>requerys ListBox2 and displays the results. 
>
>No linked tables, not working with SQL Server, and no network
>connection.
>
>ListBox2 rowsource is a Query with where matrix=FndMyMatrix()
>Requery in ListBox1 AfterUpdate.
>
>Now most of the time if I arrow up and down in the ListBox1, ListBox2 
>is requeryed and quickly displays the result. But sometimes when I open 
>the form and
>Arrow down to Item 2 in ListBox1, ListBox2 is slow to requery.
>Arrow down to Item 3 in ListBox1, ListBox2 is slow to requery.
>Arrow down to Item 4 in ListBox1, ListBox2 is slow to requery.
>Arrow down to Item 5 in ListBox1, ListBox2 is slow to requery.
>Arrow up Item 4 to Item 1 in ListBox1, ListBox2 quickly requeries.
>Arrow down Item 1 to Item 5 in ListBox1, ListBox2 quickly requeries.
>Arrow down to Item 6 in ListBox1, ListBox2 is slow to requery
>Arrow down to Item 7 in ListBox1, ListBox2 is slow to requery
>And so on.
>
>ListBox1 displays 20 items at a time.
>Sometimes I can quickly arrow down to the 20th item, but when I arrow 
>down to Item 21, ListBox2 is slow to requery and so on.
>
>This action is erractic, 99.9% of the time I have no problem opening 
>the form and quickly arrowing up and down ListBox1, then out blue the 
>above activity occurs. Because it is erratic it is making it kind of 
>hard to trap for. Anyone have any ideas as to what could be causing 
>this? Please don't tell me to tell my client not to use the arrow keys.
>
>I have decompiled and copied the mdb.
>
>Thanks
>
>  
>