How will sex be affected by my now disabled husband?

Many issues. Many issues here. Does your husband's condition prevent sex? If he can have sex, is he able to have an erection and ejaculation? Are their other physical barriers preventing sex? Are their psychological barriers? This is such a complex and important issue, that I cannot do it justice in just a few words. Discussing with your husband's doctor in an open and frank manner would be best. Good luck.
Sex after disability. Depends on what his disability is. Also the brain plays a major part in all aspects of sex so how he is mentally has major effects on your sex life.