That is your choice of course.
If you want to use VBA, your userform dialog could be used in Access as-well-as my MergeRunMDB.
That is your choice of course.
If you want to use VBA, your userform dialog could be used in Access as-well-as my MergeRunMDB.
What do you mean my userform dialog could be used in access as well as your MergeRunMDB?
Access, like MSWord and Excel has VBA. As such, you can create, import, and export Modules where my MergeRunMDB would reside and userforms where your dialog resides. It is easy. In VBE, right click the object in the Project Explorer, View > Project Explorer, and then import or export as needed.