[AccessD] List Boxes

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