[AccessD] Set Recordsource of sub Form

That's it!  Thanks.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Tuesday, April 15, 2008 12:13 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Set Recordsource of sub Form

Rocky,

Try it like this:
  Me.ClientPersonsSubFrm.Form.RecordSource = strRecordSource & " AND
MailingList = True " & strOrderBy

Regards
Steve


Rocky Smolin at Beach Access Software wrote:
> Dear List:
>  
> I can't seem to get the syntax on this right.  From a main form I want 
> to set the recordsource of a sub form.  I'm trying:
>  
>     Me.ClientPersonsSubFrm.RecordSource = strRecordSource & " AND 
> MailingList = True " & strOrderBy
> 
> but it won't compile - says 'Method of Datamember no found'.
>  
> What is the correct syntax to set the record source on a sub-form?
>  
> MTIA
>  
> Rocky
>  
> 
> 
>  	
> 	
--
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. 
Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: 4/14/2008
9:26 AM