I would wait until the morning of the needles, just mention it casually in passing and then tell him all about the wonderful treat/outing you are going on after. Tell him but just play it down like its no big deal and be super enthusiastic about the bribery to come!!! Telling too far ahead of time will give him too much time to begin stressing and getting worked up.

Just my opinion, but it worked for us.