It seems from the history that your husband is having migraine headaches
and he was receiving narcotic shots and he is not having them because of advice of your doctor.
He can take non steroidal anti-inflammatory drugs they are equally effective as narcotic analgesics. Since he is having recurrent attacks he need to use prophylactic drugs like flunarizine
or beta blockers like propranolol
Hence I advice you to consult your doctor for prescription of drugs.