[AccessD] FW: Set Recordsource of sub Form

You are correct, sir!

Thank you!

Rocky
 




 	
	

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

Forms!ClientPersons!ClientPersonsSubFrm.FORM.RecordSource
Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message -----
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, April 15, 2008 2:59 PM
Subject: [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
>
>
>
>
>
> -- 
> 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. 
Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: 4/14/2008
9:26 AM