View Single Post
  #1 (permalink)  
Old April 30th, 2005, 08:36 PM
pkaptein1 pkaptein1 is offline
Authorized User
Join Date: Apr 2005
Location: , , .
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default Create Dynamic Form; end-user adds/drops columns

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!
Reply With Quote