[AccessD] Refering to a control with a variable

That worked great - thanks :)

--- On Fri, 5/21/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: Friday, May 21, 2010, 1:10 AM


Hi Dale

Now I'm confused. I thought you were referring to:

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

Here you need to remove the last bang ("!"):

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

/gustav


>>> dkalsow at yahoo.com 20-05-2010 18:39 >>>
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



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