Charlotte Foust
cfoust at infostatsystems.com
Wed Dec 12 12:42:11 CST 2007
If you set the source through code, you shouldn't need to requery. You need to requery when the values in the current list change. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Wednesday, December 12, 2007 10:31 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Requery on setting row source or record source Dear List: When setting the record source of a form or subform or setting the row source of a combo or list box through code, is it necessary to also issue a Requery? Or does setting the source do a requery. I've got an app with some 'flicker' on opening a couple forms. On these forms I set the sources programmatically on opening and I'm thinking that some flicker may be due to unnecessary requerying. MTIA Rocky -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com