Azoospermia diagnosis

Just found out after 3 years of ttc that my husband has zero sperm. We go to the urologist and rei next month.. any positive stories?? I’ve never felt so sad in my life.. I haven’t been able to express this in front of my husband because I don’t wanna make him upset... how do you stay positive after this type of news..