To avoid ridiculous code, see

https://www.snb-vba.eu/VBA_Userform_in_database_en.html