[AccessD] Set Recordsource of sub Form

That sounds real helpful.  I can never remember when to use .Form. 

Can you mail it over?

Best,

Rocky


 




 	
	

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

William has once put together a one page list "Syntax for main/subforms"
This is a real great help on such questions.
I think it is somewhere on DBA website. If not, I can scan and mail it to
you.

Lembit

----- 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 10:02 PM
Subject: Re: [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
>
>
> -- 
> 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.524 / Virus Database: 269.22.13/1377 - Release Date: 
> 14.04.2008 09:26
>
> 

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