reference frame caption associated with a checkbox
 

Hi,

I have several frames. Each frame has 1 to 3 checkboxes. I've setup the
checkbox names so that I can loop through them using a variable (i.e.
chkChoice1, chkChoice2, chkChoice3...chkChoice20) regardless of which frame
they are in. As I am looping through the checkboxes, I am writing a row for
each checked box. However, all the information is not located in the
checkboxes. In order to finish writing the row, I need the frame caption.
How can I reference the frame caption that is associated with the checkbox as
I looped through the checkboxes?

Thanks.

reference frame caption associated with a checkbox
 

Me.Controls("chkChoice1").Parent.Caption

Regards,
Peter T

"novice973" wrote in message
...
Hi,

I have several frames. Each frame has 1 to 3 checkboxes. I've setup the
checkbox names so that I can loop through them using a variable (i.e.
chkChoice1, chkChoice2, chkChoice3...chkChoice20) regardless of which
frame
they are in. As I am looping through the checkboxes, I am writing a row
for
each checked box. However, all the information is not located in the
checkboxes. In order to finish writing the row, I need the frame caption.
How can I reference the frame caption that is associated with the checkbox
as
I looped through the checkboxes?

Thanks.

reference frame caption associated with a checkbox
 

Thank you. This is exactly what I needed!

"Peter T" wrote:

Me.Controls("chkChoice1").Parent.Caption

Regards,
Peter T

"novice973" wrote in message
...
Hi,

I have several frames. Each frame has 1 to 3 checkboxes. I've setup the
checkbox names so that I can loop through them using a variable (i.e.
chkChoice1, chkChoice2, chkChoice3...chkChoice20) regardless of which
frame
they are in. As I am looping through the checkboxes, I am writing a row
for
each checked box. However, all the information is not located in the
checkboxes. In order to finish writing the row, I need the frame caption.
How can I reference the frame caption that is associated with the checkbox
as
I looped through the checkboxes?

Thanks.