Loop through all controls in form frame340

[ped]

Hi is there a way to loop through all controls in form frame340 and check for texbox type and then their values?

Thanks in advance.

I could not get suitable code....i did tried searching

[pbaldy]

This template code should get you started:

  Dim ctl As Control

  For Each ctl In Me.Controls   
    Select Case ctl.ControlType
      Case acTextBox
       'do whatever
    End Select
  Next ctl

[ped]

Paul, thanks for getting me started...

tried this way and nothing happened..

Dim ctl As Control
  For Each ctl In Me.Frame7.Controls
    Select Case ctl.ControlType
      Case acTextBox
       MsgBox ctl.Value
    End Select
  Next ctl

[pbaldy]

I think you can only refer to the form, not the frame. To only look within a frame you'd probably need to use the Tag property and test that:

If ctl.Tag = "Whatever" Then

That said, controls within a frame don't typically have a Value property (though I've never seen a textbox within a frame). The frame contains the value of the group.

[ped]

Paul, that will solve my problem...thanks a lot!

[pbaldy]

No problem ped!