John Ruff
papparuff at comcast.net
Tue Apr 15 14:56:43 CDT 2008
Rocky, Me!ClientPersonsSubFrm!Form!RecordSource= or Me.ClientPersonsSubFrm.Form.RecordSource= papparuff 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 12:40 PM Subject: Re: [AccessD] FW: Set Recordsource of sub Form > John: > > It doesn't get to the right side of the =. > > Using: > > Forms!ClientPersons!ClientPersonsSubFrm.RecordSource = > > I get object doesn't support this property or method. > > Rocky > > > > > > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Ruff > Sent: Tuesday, April 15, 2008 12:07 PM > To: Access Developers discussion and problem solving > Subject: Re: [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 > > -- > 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