[AccessD] Refering to a control with a variable

I know that me is refering to the current form but I do not see a "me" in the statment I am using (Forms![frmDate]![frmsubMonth].Form!("subFrom" & intloop & "").visible = False).  Would you mind just give the the syntac that will work? :)
 
thanks!
 
Dale

--- On Thu, 5/20/10, Gustav Brock <Gustav at cactus.dk> wrote:


From: Gustav Brock <Gustav at cactus.dk>
Subject: Re: [AccessD] Refering to a control with a variable
To: accessd at databaseadvisors.com
Date: Thursday, May 20, 2010, 11:34 AM


Hi Date

Me is always the calling form.
The syntax that worked is how to call a (sub)subform.

/gustav


>>> dkalsow at yahoo.com 20-05-2010 18:12 >>>
Sorry,

I don't understand why it is looking in the current form?  How do I tell it the subform than?

--- On Thu, 5/20/10, Gustav Brock <Gustav at cactus.dk> wrote:


From: Gustav Brock <Gustav at cactus.dk>
Subject: Re: [AccessD] Refering to a control with a variable
To: accessd at databaseadvisors.com 
Date: Thursday, May 20, 2010, 10:45 AM


Hi Dale

The last one would (if brushed up) try to reference a control on the calling form (Me) which is not what you want.

/gustav


>>> dkalsow at yahoo.com 20-05-2010 17:34 >>>
That worked Great - thanks!

Now----- why does the 2nd line work but not the 3rd?

intloop=8
Forms![frmDate]![frmsubMonth].Form![subForm8].visible = False
Forms![frmDate]![frmsubMonth].Form!("subFrom" & intloop & "").visible = False

Thanks Again!

Dale

--- On Thu, 5/20/10, Gustav Brock <Gustav at cactus.dk> wrote:


From: Gustav Brock <Gustav at cactus.dk>
Subject: Re: [AccessD] Refering to a control with a variable
To: accessd at databaseadvisors.com 
Date: Thursday, May 20, 2010, 9:52 AM


Hi Dale

This should do:

    Forms![frmDate]![frmsubMonth].Form("subForm" & intLoop & "").Form![lblDate].Caption = "Access"

/gustav


>>> dkalsow at yahoo.com 20-05-2010 16:31 >>>
Good Morning,

This is what I am trying to do:

    Forms![frmDate]![frmsubMonth].Form![subForm8].Form![lblDate].Caption = "jj"
    Dim intLoop As Integer
    intLoop = 8
    Me.Controls.Item("Forms![frmDate]![frmsubMonth].Form![subForm" & intLoop & "].Form![lblDate]").Caption = "Access"

The first line works.  Can anyone tell me why the last one does not?

Thanks in advance.

Dale
--- On Wed, 5/19/10, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:


From: Stuart McLachlan <stuart at lexacorp.com.pg>
Subject: Re: [AccessD] Refering to a control with a variable
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Date: Wednesday, May 19, 2010, 10:15 PM


Me.Controls.Item("txtbox" & Trim(Str(IntA)))

(the "Me." is optional)

-- 
Stuart


On 19 May 2010 at 19:17, Dale_Anne Kalsow wrote:

> Good Evening,   If I have a control named txtbox1 and a variable of intA
> with a value of 1, does anyone know how to refer to the control in VBA
> with with something simular to "txtbox" & intA?   Thanks!   Dale 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com