"Or" Operator problem

[WE LUV MASSEY]

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

[kleinma]

i am thinking maybe because you have

If txtAuthor.Text = " " Or txtName.Text = " " Or txtAddress.Text = " " Then

maybe try to put in

If txtAuthor.Text = "" Or txtName.Text = "" Or txtAddress.Text = "" Then

it looks like you are checking for a space where you really are looking for empty strings.

[Pickler]

If txtAuthor.Text = " " Or txtName.Text = " " Or txtAddress.Text = " " Then
should be
If txtAuthor.Text = "" Or txtName.Text = "" Or txtAddress.Text = "" Then

( no spaces between "" )

[WE LUV MASSEY]

Your a living legend!

Appreciate that.

[Bruce Fox]

You could try dropping the ELSE too.

ie.

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
  [b]Exit Sub[/b]
 End If
End If
'
rs1.AddNew  'Whatever else here
'
End Sub

[mendhak]

Also try putting in a breakpoint there and checking the values when it breaks. It's probably because of the spaces.