In forms I've customized for clients in the past, I've always placed each static field label in the form's header with corresponding variable table data in the form's detail. A current client wants to be able to add and delete columns, at will from a form she uses, via a GUI interface provided by MS Access. Can someone advise on how to design a form to be dynamic such that the end-user may pull into the form only the columns they need, or add new columns to an existing form, or drop unnecessary columns with columns maintaining headers?
If you have done this in the past, would you be willing to attach or email me a sample Access Database or sample code? I am experienced with MS Access but somewhat of a novice with modules/vba code but very willing to learn what is needed to solve this matter!