This is my code:


Private Sub cmdAdd_Click()

If rs2.NoMatch Then
If txtAuthor.Text = " " Or txtName.Text = " " Or txtAddress.Text = " " Then
rs1.AddNew
rs1.Fields("Comment") = "Insufficient Author Data"
rs1.Update

Else
rs1.AddNew.......

The problem is that if either of the author, name, or address text boxes are empty on my form, the code just jumps down to the Else instead of rs1.AddNew (after Then)

What am I doing wrong please???
Else