I am sure some of you have thought of this before and that must be a way to do it.
What I am looking for here is a way to dynamically via VBA create forms based off a template form for all look up tables.
For example, in most of my applications I have tables for users, salutations, access levels, etc. All those little tables that we use to populate some combobox to make user interface easier, and better yet prevent data issues.
What I am looking for is perhaps a function where I can name a table and a form template and bam a form with all the fields for that table are created. I am trying to automate some of the simpler tasks that are becoming time consuming and mundane. I could then just create a single form that points the user to one location to make updates to any of these small tables.
Thanks in advance.