[AccessD] Best way to requery a list box in Access 2003

John W. Colby jwcolby at colbyconsulting.com
Wed Dec 22 08:05:34 CST 2004


You need to open the popup form modal so that execution stops in the routine
that opens the popup.  Then when the modal form closes, execution resumes
and you immediately requery the combo.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeff Barrows
Sent: Wednesday, December 22, 2004 8:50 AM
To: AccessD
Subject: [AccessD] Best way to requery a list box in Access 2003


I have a data entry form that uses dropdown lists to verify data exists.  If
the data does not exist, the user is redirected to the entry screen for the
missing information.  My problem occurs when the user closes the second
entry screen.  The list box on the first screen needs to be requeried, but I
cannot seem to find the correct location to place the command.  Any
suggestions???   
 
 
Jeff B
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list