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