[AccessD] FW: Set Recordsource of sub Form

If strRecordSource is a string, should it not be surrounded by quotes?
Forms!ClientPersons!ClientPersonsSubFrm.RecordSource = "'" & strRecordSource 
& "' AND MailingList = True " & strOrderBy

John V. Ruff

Applications Support Analyst

SolutionsIQ


----- 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 11:59 AM
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