Combo Box To Hide Tab Control

Compile error:

End If without block If

"kabaka" wrote:



I tried inserting a break after the first line nd it gives me an error
message so I know its reading the code.


what is the error message?

If you'd like gimme a generic email address and Ill email this sucker to you

"kabaka" wrote:



I tried inserting a break after the first line nd it gives me an error
message so I know its reading the code.


what is the error message?

Post all the code for the entire AfterUpdate() event where you are getting
your error. If all that you are missing is an "End if" to get this working,
I'll know that I've been at the office too long today and it's time to go
home.



"Lowrider72" wrote:

Compile error:

End If without block If

"kabaka" wrote:



I tried inserting a break after the first line nd it gives me an error
message so I know its reading the code.


what is the error message?

I wish it was that simple...here is the entire code..

Private_Sub cboComboBox_AfterUpdate()
If Me.cboComboBox.Value = "Suspect" Then
Me.tester.Visible = True
End If
End Sub

"kabaka" wrote:

Post all the code for the entire AfterUpdate() event where you are getting
your error. If all that you are missing is an "End if" to get this working,
I'll know that I've been at the office too long today and it's time to go
home.



"Lowrider72" wrote:

Compile error:

End If without block If

"kabaka" wrote:



I tried inserting a break after the first line nd it gives me an error
message so I know its reading the code.


what is the error message?

Opps, the one with the error is as follows...

Private_Sub cboComboBox_AfterUpdate()
If Me.cboComboBox.Value = "Suspect" Then _
Me.tester.Visible = True
End If
End Sub


"Lowrider72" wrote:

I wish it was that simple...here is the entire code..

Private_Sub cboComboBox_AfterUpdate()
If Me.cboComboBox.Value = "Suspect" Then
Me.tester.Visible = True
End If
End Sub

"kabaka" wrote:

Post all the code for the entire AfterUpdate() event where you are getting
your error. If all that you are missing is an "End if" to get this working,
I'll know that I've been at the office too long today and it's time to go
home.



"Lowrider72" wrote:

Compile error:

End If without block If

"kabaka" wrote:



I tried inserting a break after the first line nd it gives me an error
message so I know its reading the code.


what is the error message?

ok - I won't be able to look at if for about 1 1/2 hours though. Sorry.

Note: It's not a good idea to post email addresses in a newsgroup as
spammers harvest them from here (or so I've heard). You should be able for
figure out my email address though.

cpalmer at shaw dot ca


"Lowrider72" wrote:

If you'd like gimme a generic email address and Ill email this sucker to you

"kabaka" wrote:



I tried inserting a break after the first line nd it gives me an error
message so I know its reading the code.


what is the error message?

ARRGHHHH!!

Loose the "_" after the Then and you'll be good to go. That's throwing off
your if.






"Lowrider72" wrote:

Opps, the one with the error is as follows...

Private_Sub cboComboBox_AfterUpdate()
If Me.cboComboBox.Value = "Suspect" Then _
Me.tester.Visible = True
End If
End Sub


"Lowrider72" wrote:

I wish it was that simple...here is the entire code..

Private_Sub cboComboBox_AfterUpdate()
If Me.cboComboBox.Value = "Suspect" Then
Me.tester.Visible = True
End If
End Sub

"kabaka" wrote:

Post all the code for the entire AfterUpdate() event where you are getting
your error. If all that you are missing is an "End if" to get this working,
I'll know that I've been at the office too long today and it's time to go
home.



"Lowrider72" wrote:

Compile error:

End If without block If

"kabaka" wrote:



I tried inserting a break after the first line nd it gives me an error
message so I know its reading the code.


what is the error message?

okay..I was under the impression everyone had a garbage hotmail account for
instances such as this lol...Hotmail is good for that..I'll send it to you
and whenever you get the chance have a look...Its the one that i have created
as a test...I've been banging my head off my desk for a few hours over this
one...I really appreciate your time and effort..

Regards

"kabaka" wrote:

ok - I won't be able to look at if for about 1 1/2 hours though. Sorry.

Note: It's not a good idea to post email addresses in a newsgroup as
spammers harvest them from here (or so I've heard). You should be able for
figure out my email address though.

cpalmer at shaw dot ca


"Lowrider72" wrote:

If you'd like gimme a generic email address and Ill email this sucker to you

"kabaka" wrote:



I tried inserting a break after the first line nd it gives me an error
message so I know its reading the code.


what is the error message?

Ya I know...but you suggested inserting a break so I did and I got that error
message

"kabaka" wrote:

ARRGHHHH!!

Loose the "_" after the Then and you'll be good to go. That's throwing off
your if.






"Lowrider72" wrote:

Opps, the one with the error is as follows...

Private_Sub cboComboBox_AfterUpdate()
If Me.cboComboBox.Value = "Suspect" Then _
Me.tester.Visible = True
End If
End Sub


"Lowrider72" wrote:

I wish it was that simple...here is the entire code..

Private_Sub cboComboBox_AfterUpdate()
If Me.cboComboBox.Value = "Suspect" Then
Me.tester.Visible = True
End If
End Sub

"kabaka" wrote:

Post all the code for the entire AfterUpdate() event where you are getting
your error. If all that you are missing is an "End if" to get this working,
I'll know that I've been at the office too long today and it's time to go
home.



"Lowrider72" wrote:

Compile error:

End If without block If

"kabaka" wrote:



I tried inserting a break after the first line nd it gives me an error
message so I know its reading the code.


what is the error message?

Say that again... what did you do when you inserted a break? What I meant
was click on the left of the module (in the rectangle that runs beside the
code - it's offcoloured - if you did it right your line will be highlighted
and a big red dot will be beside the line) not insert a "_". That isn't a
break point.

"Lowrider72" wrote:

Ya I know...but you suggested inserting a break so I did and I got that error
message

"kabaka" wrote:

ARRGHHHH!!

Loose the "_" after the Then and you'll be good to go. That's throwing off
your if.






"Lowrider72" wrote:

Opps, the one with the error is as follows...

Private_Sub cboComboBox_AfterUpdate()
If Me.cboComboBox.Value = "Suspect" Then _
Me.tester.Visible = True
End If
End Sub


"Lowrider72" wrote:

I wish it was that simple...here is the entire code..

Private_Sub cboComboBox_AfterUpdate()
If Me.cboComboBox.Value = "Suspect" Then
Me.tester.Visible = True
End If
End Sub

"kabaka" wrote:

Post all the code for the entire AfterUpdate() event where you are getting
your error. If all that you are missing is an "End if" to get this working,
I'll know that I've been at the office too long today and it's time to go
home.



"Lowrider72" wrote:

Compile error:

End If without block If

"kabaka" wrote:



I tried inserting a break after the first line nd it gives me an error
message so I know its reading the code.


what is the error message?