drinking to have sex

Me and my husband has been together for 7 years and our sex life was on fire until after years of TTC and no luck. we barely do it. he does not drink or smoke and until he wants it then we will have some action. this past Saturday a friend offer him a beer and he decided to try it and i think 3 cans got him twist to the point he wants sex everytime. should i let him start drinking so we can have sex more often and maybe get pregnant or not?...