I was trying to run this code in VBA and it doesn't work. I got an error saying "Object doesn't support this property or method" (it stops in very first line of For Each statement. I tried to do it in Visual Basic and it worked. Do you have any ideas why it doesn't work in VBA?
Here is the code:
Code:
Private Sub txtFirstWestOne_Change()
    Dim stText As String
    stText = txtFirstWestOne.Text
    
    For Each Control In Me
        If TypeOf Control Is TextBox Then
            If Control.Text = stText Then
                MsgBox "Something"
            End If
    End If
    Next
End Sub
Thanks, and happy Thanksgiving!!!

------------------
Visual Basic Programmer (at least I want to be one)
------------------
PolComSoft
You will hear a lot about it.



[This message has been edited by QWERTY (edited 11-25-1999).]