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