Loop Through Detail Section Record Controls

[Mike]

Hi. I need to add an image to the detail section of a subform, and then
toggle it's Visibility based on another value in that particular record. The
loop I build to do this only seems to read the FIRST detail section record
(shown below). How can my loop read each record in the detail section?

Dim ctl As Control
For Each ctl In Me.Detail.Controls
If (ctl.Name = "imgPendingRenew") Then
ctl.Visible = RenewIsPending(Me.txtUniqueID)
End If
Next


Thanks!

 

[Arvin Meyer MVP]

Try using the recordsetclone of the subform. Your code, btw, only looks at
one record.

 

[Stuart McCall]

Hi. I need to add an image to the detail section of a subform, and then
toggle it's Visibility based on another value in that particular record.
The
loop I build to do this only seems to read the FIRST detail section record
(shown below). How can my loop read each record in the detail section?

Dim ctl As Control
For Each ctl In Me.Detail.Controls
If (ctl.Name = "imgPendingRenew") Then
ctl.Visible = RenewIsPending(Me.txtUniqueID)
End If
Next


Thanks!

This reference is the wrong syntax:

Me.Detail.Controls

It should be:

Me.Section(acDetail).Controls

 

[Marshall Barton]

This reference is the wrong syntax:

Me.Detail.Controls

It should be:

Me.Section(acDetail).Controls

Stuart , if the detail section is named Detail (the default
name), then either syntax will work. There was a bug in
A2002 that kind of messed with some references tp an item in
a section's Controls collection, but For Each was fine.

 

[Stuart McCall]

Stuart , if the detail section is named Detail (the default
name), then either syntax will work. There was a bug in
A2002 that kind of messed with some references tp an item in
a section's Controls collection, but For Each was fine.

Maybe it was that bug which prompted me to always use the syntax I posted.
Can't remember.

Thanks for the clarification, Marsh.

To Mike: please just ignore my post.

 

[Mike]

Thanks all for your responses. This is a continuous form, so it doesn't
sound like this is possible.

Mike