Ttc after miscarriage

I really badly want a child and was excited when I found out I was pregnant. Ten weeks into the pregnancy the doctor told us that he couldn't find a heart beat 💔, my fiancee and I broke down in the office. We learned now that after a miscarriage it's best to ttc 3-6 months after because it lowers the chance of another miscarriage which got me excited. My fiancee is so scared that we're going to have another miscarriage that he doesn't even want to try, what should I do?