Thank you so much for sharing this knowledge, I'm new to Microsoft Access and VBA. Just attempted using your steps in my work and it keeps returning user-defined not defined, I have tried gone through all the codes yet the same thing, when I now copied my own form to your application, it worked...