Whats wrong with this IF

Brucelee · Apr 14th, 2002, 04:47 AM

Private Sub CommandButton1_Click()
If TextBox1 = "" Then
Call Search_productnumber(TextBox2)
If TextBox2 = "" Then
Call Search_productname(TextBox1)
Else
Call Search_productname(TextBox1)
Call Search_productnumber(TextBox2)
End If
End If
End Sub

This If statement is supposed to search either textbox1 or textbox2 on a userform when the command button is clicked. I can't see what is wrong with it, could someone please help!

smozgur · Apr 14th, 2002, 05:06 AM

elseIf in 4. line of your code

Private Sub CommandButton1_Click()
If TextBox1 = "" Then
Call Search_productnumber(TextBox2)
elseIf TextBox2 = "" Then
Call Search_productname(TextBox1)
Else
Call Search_productname(TextBox1)
Call Search_productnumber(TextBox2)
End If
End If
End Sub

Regards

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 14th, 2002, 04:47 AM	#1
Brucelee New Member Join Date: Apr 2002 Posts: 7	Private Sub CommandButton1_Click() If TextBox1 = "" Then Call Search_productnumber(TextBox2) If TextBox2 = "" Then Call Search_productname(TextBox1) Else Call Search_productname(TextBox1) Call Search_productnumber(TextBox2) End If End If End Sub This If statement is supposed to search either textbox1 or textbox2 on a userform when the command button is clicked. I can't see what is wrong with it, could someone please help!

Apr 14th, 2002, 05:06 AM	#2
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	elseIf in 4. line of your code Private Sub CommandButton1_Click() If TextBox1 = "" Then Call Search_productnumber(TextBox2) elseIf TextBox2 = "" Then Call Search_productname(TextBox1) Else Call Search_productname(TextBox1) Call Search_productnumber(TextBox2) End If End If End Sub Regards