[AccessD] Requery on setting row source or record source

Thanks Charlotte.  Commenting out all them extraneous requeries now.

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Wednesday, December 12, 2007 10:42 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Requery on setting row source or record source

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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.503 / Virus Database: 269.17.1/1181 - Release Date: 12/11/2007
5:05 PM