[AccessD] Set Recordsource of sub Form

Lembit Soobik lembit.dbamail at t-online.de
Tue Apr 15 16:04:55 CDT 2008


done

----- 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:45 PM
Subject: Re: [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
>
>
> -- 
> 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
>
> 




More information about the AccessD mailing list