Lembit Soobik
lembit.dbamail at t-online.de
Tue Apr 15 15:34:04 CDT 2008
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 > >