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

Hi Christopher:

Did you see this entry at the DBA web site?
http://www.databaseadvisors.com/newletters/newsletter032004/0310ReferenceGui
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