To help his disappointment you might share a story of something that happened in your life that was a big disappointment at the time but, in retrospect, turned out to be for the best. Kids don't have as much experience with these kinds of things to fall back on, but we can share ours. Good luck!