I have a db with many users...
Two of those users I consider Admin Users and I need to give them access to about 10 tables (for data manipulation).
The easy thing to do would be a simple docmd.opentable or docmd.openquery, but I understand how/when to use access objects and I'd like to use a form and its various properties.
My problem/question is that I do not want to create 10 new form objects in my database!
I'd like to create 1 form and set its properties to the desired specs (e.g., datasheet view, pop up, allow additions = no, etc.) and then in code manipulate its recordsource based on what recordset the user wants to work with.
What I just described is obviously pretty simple, but once I set the form's recordsource, I need to then bring in all the fields (which I've always done manually).
Is there a way to dynamically set a form's recordsource AND then add all fields into the form (since the form's view is datasheet, I don't care about how the controls are set)?