[AccessD] A2K: Syntax - Manipulating a sub-subform?

Christopher Hawkins clh at christopherhawkins.com
Wed Apr 14 23:08:16 CDT 2004


Thanks!  I'll try this out tomorrow...

-Christopher-

---- Original Message ----
From: accessd at shaw.ca
To: accessd at databaseadvisors.com, 
Subject: RE: [AccessD] A2K:  Syntax - Manipulating a sub-subform?
Date: Wed, 14 Apr 2004 20:16:32 -0700

>Hi Christopher:
>
>Did you see this entry at the DBA web site?
>http://www.databaseadvisors.com/newletters/newsletter032004/0310Refer
>enceGui
>de/SyntaxForSubs.htm (watch for wrap)
>
>HTH
>Jim
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Christopher
>Hawkins
>Sent: Wednesday, April 14, 2004 4:07 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] A2K: Syntax - Manipulating a sub-subform?
>
>
>First, the setup:
>
>Form frmMain contains a subform object named sFrmFind.  sFrmFind's
>SourceObject is frmFind.
>
>frmFind contains a subform object named sFrmResults.  sFrmResults'
>SourceObject is frmResults.
>
>frmResults is a datasheet with fields such as FirstName, LastName,
>etc.
>
>Now, my question...once frmMain is open and showing me my subforms,
>how do I change the .ColumnOrder of a field in frmResults from within
>the Click event of a button on frmFind?
>
>Forms!frmMain.sFrmFind.Form!sFrmResults.Form("FirstName").ColumnOrder
>= 1 isn't doing it.
>Me.parent.sFrmFind.Form!sFrmResults.Form("FirstName").ColumnOrder = 1
>isn't doing it either.
>
>I keep getting 'Application-defined or object-defined error' when
>either of those lines try to execute.
>
>I'm oviously overlooking some nuance of syntax.
>
>If I'm true to form, I'll have "one more idea" and fix it immediately
>after clicking 'Send' on this eMail.  But by all means, suggest some
>syntax anyway.  :)
>
>-Christopher-
>
>
>--
>_______________________________________________
>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
>
>





More information about the AccessD mailing list