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

Nicholson, Karen cyx5 at cdc.gov
Wed Dec 22 08:16:29 CST 2004


In the onclose event of the form that you are entering the new data in,
do an 
If Isloaded("frmname") then
Formname.fieldname.refresh or requery, I forget.
End if


-----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