HI All,

I am now trying to display a message when I am writing info to a database that warns me to fill in all fileds(text boxes) before the operation(write to the database) can take place.
I want to test all text boxes at once instead of typing each textbox value in an if statement.
aaa
For example:
Instead of typing

if txtBox1.text = "" and txtbox2.text = "" .........
msgbox "Please fill out all fields before writing to database"
end if

I tried the code below, but am getting errors

Private Sub cmdAdd_Click()

Dim Contrl As Control

For Each Contrl In frmForm.Controls
If (TypeOf Contrl Is TextBox) And
frmForm.Contrl.Text = "" Then
MsgBox "Please fill in all fields"
txtBox1.setfocus
End If
Next Contrl

I get a compile error when I hit the Add button. The message I get is Method or data member not found and Contrl is highlighted. I have tried a few other things, but of course they did not work. Any help would be much appreciated.

Thanks in advance!!!