John W. Colby
jwcolby at colbyconsulting.com
Wed Dec 22 09:38:39 CST 2004
Susan, That certainly works but should be applied judiciously. Imagine 50 users in a form tabbing through entering data all day long. Each field is a combo pulling 5000 records. You would have a TON of database activity (and slow combo functionality) just to ensure that the user had the "most up to date data". In my framework, I have a NotInList that fires if the data entered is not in the combo already. If it fires, then I can decide whether to requery the combo or open a form and try to find the record. If the record is not found I move to the new record for new data entry. Either way, the data is pulled ONLY if the data being entered is not in the list. 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 Susan Harkins Sent: Wednesday, December 22, 2004 10:13 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Best way to requery a list box in Access 2003 You could requery every time is gets the focus. That way it's always the most up-to-date information, even if the user hasn't just closed a screen. Susan H. 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??? -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com