Use a userform for the input.

Take a look here for more explanation
http://www.snb-vba.eu/VBA_Userform_in_database_en.html