Add New Controls through Code
Instead of having a fixed set of controls that you've manually added to a form, though code, allow it to dynamically add new controls.
Joe/Mark, I'll give your suggestions a go, thanks. I also redesigning the Access Front end to be more "organic" (some of the code is 15 years old), to not require dynamically generated (or pre-generated) controls to exist.
Mark Burns commented
I have not experimented - and this is just a thought...but if the compiled database had an un-compiled add-in database, could the (compiled) code do the dynamic forms build/load work from in that database container? ...and could the add-in database successfully use the database objects in the compiled db (or another add-in?) as bindable data sources?
"You can add control dynamically through VBA using the CreateControl Method"
Just an FYI ... whereas this does work in 'live mode' (per the one comment), it will NOT work in and MDE or ACCDE ... since you cannot make design changes to a Form in a 'DE'. Keep this in mind.
Hiding/unhiding existing controls is exactly what I do at present, it's just a real pain to create many hundreds of controls for certain "dynamic" forms to cover the worst case scenarios. Just would be nice and easier to programmatically create the correct amount through code in real time.
Alan Cossey commented
Is there a situation where just unhiding existing controls is not as useful?
If I'm not mistaken, from my quick test, CreateControl only works when you are in design or layout mode not a live mode. Perhaps you could create a form live using CreateControl and save and open it, but what I'm after is having a pre-existing form where you can dynamically add new controls as you see fit in a live situation.
Please correct me if I'm wrong.
You can add control dynamically through VBA using the CreateControl Method (https://msdn.microsoft.com/en-us/library/office/aa221167(v=office.11).aspx). Does this not do what you need?