Subform "Column Choose" Functionality

Posted on 2016-11-08
Medium Priority
Last Modified: 2016-11-08
I have a standard Access form with a subform drawing fields from a Project table. The table itself has about 25 fields and the subform is showing about 5. There has been a request to allow end-users to select the fields they want to show on the subform.

Is there a common best-practice way to do this? I though about toggling the .visible property but think that would leave holes where the not-visible fields are.

Any input is welcome!

Question by:Michael Vasilevsky
  • 2
LVL 50

Accepted Solution

Dale Fye earned 2000 total points
ID: 41878632
You could use a datasheet as the subform, which would allow the users to hide or drag columns into the position you want them in.  I actually have an article on how to do this, located here.
LVL 11

Author Closing Comment

by:Michael Vasilevsky
ID: 41878801
Perfect - thanks!
LVL 50

Expert Comment

by:Dale Fye
ID: 41878812
glad I could help

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question