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!