[onewhippedpuppy]

Originally Posted by Christien

Ok, in doing that test, the meter spiked, there was a very tiny spark at the black wire (using black and red), and at that moment, there was power to the light fixture. I didn't dare hold it there long. Can't really get a pic of me doing it without a third hand, but this gives you an idea

You completed the circuit using your multimeter.....and probably fried it. On the upside, you connected the red and black and the light worked, right? That means you have power in the box and the wiring to the light is good, meaning the problem is in the box. Either you have a loose connection somewhere in the box or the switch is bad. If nothing else you could spend $1.00 and swap out the switch to eliminate that possibility, that would let you avoid buying a new multimeter.