[AccessD] List Boxes

Hey Lambert
Thank you for your response.
Tried the Enabled, but what happens is the originating list box goes 
blank while the requerying is going on. Works but the blank is annoying. 
I had previously tried Locked but it causes the list box to display 
multiple highlights (as I click) until I go back a list box and then 
requery.

Heenan, Lambert wrote:

>In the code that kicks off the requery you could probably first loop though all the listboxes and sent their enabled property to False.
>
>Pseudo-code
>
>	For Each ListBox In Me
>		ListBox.Enable=False
>	Next ListBox
>	Requery
>	For Each ListBox In Me
>		ListBox.Enable=True
>	Next ListBox
>
>Lambert
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
>Sent: Wednesday, December 15, 2010 11:41 AM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] List Boxes
>
>Hey All
>I have a series of 9 list boxes on a form. Sort of a drill down, the user selects an item in a list box and it then displays (waterfalls) the results in the following list boxes. For 60,000 records it takes about
>2  to 3 seconds to refresh/requery all the list boxes.  One thing I don't quite understand is why when I manually open a query used for a list box it is quite fast, but when the list box gets requeried on the form there is noticable time lag. I can live with the 2 to 3 second delay time but what I am finding is as the program  requeries the other list boxes I can click on the originating list box  and I get the error message "The macro or function set to the BeforeUpate or ValidationRule......" .  The only event on the list box is an On Click. 
>I have tried several approaches to try and prevent the user clicking before all requeries are completed. Is there a way to disable the cursor while  the code is running??
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>