Codeine itself can cause seizures but usually if there is some underlying factor. Always a good idea not to take others meds. Urgent care is a waste of time.
Sounds like your hubby needs a physical with blood work as a starter. If they classified it as a seizure and not just syncope or if not sure then an EEG is warranted. Good luck to him