[AccessD] FW: Set Recordsource of sub Form

P.S.    Forms!ClientPersons!ClientPersonsSubFrm.RecordSource =
strRecordSource & " AND MailingList = True " & strOrderBy
 
doesn't work either. :(
 
Rocky
 



 	
	
 

  _____  

From: Rocky Smolin at Beach Access Software [mailto:rockysmolin at bchacc.com] 
Sent: Tuesday, April 15, 2008 11:54 AM
To: 'Access Developers discussion and problem solving'
Subject: Set Recordsource of sub Form


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