[AccessD] Name of label associated with a text box

Google rules. :-)

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, December 18, 2014 2:18 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Name of label associated with a text box

Why AccessD has less activity?  I found the answer on the web:

Dim ctl as Control

Set ctl = Me(gstrActiveControl)
 
Associated label name is in ctl.Controls(0).Name

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, December 18, 2014 10:59 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Name of label associated with a text box

Dear List:
 
I need to get the name of the label associated with a text box or combo box.
I can get the name of the control no problem using Screen.ActiveControl.Name.  Is there a way then to get the name of the label attached to that control?
 
MTIA
 
Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com <http://www.e-z-mrp.com/>
Skype: rocky.smolin
 
--
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