It looks like it should work. Are you sure you don't have typos?
>Hi All!
>
>I have a complicated If statement that I will like to convert to Select Case but the expresion that I have in the IF is a little difficult. Maybe someone already did it, let see,.
>
>If TypeOf rptVendorPayeeReport Is ExportReport Then
>some code
>else
>If TypeOf rptVendorPayeeReport Is ReportListingThen
>some code
>else
>If TypeOf rptVendorPayeeReport Is ReportListing2 Then
>
>an continue six level down.
>
>I will like to make it Select Case but that give me an error,. sound logic this way
>
>Select case TypeOf rptvendorPayeeReport is
>
>case Report listing
>
>.....
>
>end select
>
>But does not work.. Any Idea are welcome.
>
>TIA
If it's not broken, fix it until it is.
My Blog