Yeah its a shitty situation for all involved. If you can't get enough for him to go, perhaps you could try and make up by spending a day with him doing fun stuff? Movies or getting lunch or something.