Husband is "turned off" by TTC-ing, how to get him to bd?

Okay well we are trying for our first and over the last few monthes I am not suprised we have failed because there is less each month! Last night I had a serious talk with him about how this is for our future and we need to have in order to make the baby we want and he finally told me he is just turned off by the whole thing and just leave it alone it will "just happen" if we don't try, which makes no sense because you HAVE to have to get pregnant, I told him even the teengagers that get pregnant had to have and they weren't even trying, and he said "yeah well at least they wanted the , when I hear you talking about mucus all I picture is having with a runny nose", which made me laugh and mad at the same time. He has actually started trying to bribe me with bubble baths and shopping to get me to NOT have sex with him, what the hell right? So anyways I am ovulating soon and need to get him in bed, how??? We've tried dress up, public places- my car in the drive way lol, and a bunch of other stuff but he doesn't want sex, please help!!!