[AccessD] Set Recordsource of sub Form

Steve Schapel miscellany at mvps.org
Tue Apr 15 14:13:10 CDT 2008


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
>  
> 
> 
>  	
> 	



More information about the AccessD mailing list