Looping through controls looking for nulls

[BukHix]

I have a form with 15 text boxes on it. I am looking for an efficient way to loop through all the text boxes looking for nulls before I commit a DB transaction.

I know I can do a series of IF Thens but there has to be a better way. I assume there is a way to loop through the controls so I am looking for a sample that will help me et started. Also is it possible to send the focus to the first textbox error found in the loop?

[Edneeis]

This will loop through all the textboxes on the form itself (not on another container that is on the form):

For Each txt As TextBox In Me.Controls
  If txt.Text=String.Empty Then DoSomething
Next

[BukHix]

Hmmm am I missing something?

       Dim txty As TextBox
        For Each txty In Me.Controls
            If txty.Text = String.Empty Then MsgBox("OOPS")
            Exit Sub
        Next

Gives me this error

An unhandled exception of type 'System.InvalidCastException' occurred in RP_6.0.exe

Additional information: Specified cast is not valid.

It then highlights this line For Each txty In Me.Controls. It does this regarless of whether I alter it as I did in my post or use it exactly like you posted it.

[Edneeis]

Do you have Option Strict on? Try this:

Dim ctrl As Control
        For Each ctrl In Me.Controls
            If typeof ctrl Is Textbox AndAlso DirectCast(ctrl,TextBox).Text=String.Empty Then
                  MsgBox("OOPS")
                  Return
            End If
        Next

[BukHix]

Thanks Edneeis that did the trick.