[AccessD] Requery on setting row source or record source

Just remember, if you are using a NotInList routine to add items to the
Combobox rowsource, you will need to requery. 

Charlotte

-----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 11:39 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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