IF Logic

[skull_eagle]

Hi,

I'm struggling with the logic with this one.

Both IF statements work fine on their own, combined I'm getting MtrxSub sub called up to 4 times.

Thank you

Private Sub Matrix_BTN_Click()


If Search_Form.Controls("TB_71") <> "" Then

Worksheets("Admin").Range("P8").Value = Search_Form.Controls("TB_71")

Call MtrxSub

Else

MsgBox "Please enter a Job Number"

Exit Sub

End If


If Search_Form.Controls("Results_1").Caption <> "0" Then

Worksheets("Admin").Range("P8").Value = Search_Form.Controls("TB_71")

Call MtrxSub

Else

MsgBox "No results to display"

Exit Sub

End If


End Sub

 

[nemmi69]

Is that the IFs combined? What does MtrxSub contain?

 

[skull_eagle]

Is that the IFs combined? What does MtrxSub contain?

MtrxSub is just a reporting sub that works perfectly.
The issue is calling the sub based on these 2 criteria.

 

[nemmi69]

How was "Search_Form.Controls" defined?

 

[skull_eagle]

How was "Search_Form.Controls" defined?

I think this is an IF, THEN, ELSE syntax error.