[AccessD] List Boxes

What about...

	For Each ListBox In Me
		ListBox.Enable=False
	Next ListBox
	Application.Echo False
	Requery
	Application.Echo True
	For Each ListBox In Me
		ListBox.Enable=True
	Next ListBox

That should prevent the boxes going blank during the requery. 

And also be sure to include Application.Echo True in your error handler.

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 1:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
>  
>

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com