Need a light fixture over sink before I take a gun and shoot this one!

Got a connection problem..sometime it works and of course most of the time it does not.



think it is a switch problem..what about a new one..where? 1999 Excella..you know those 2 light jobies with the switch in the middle.