MS Access - Dynamically select fields prior to opening a form
Posted on 2014-07-27
Is there a way to dynamically to select fields on a form?
I created a form and set the recordsource to a query. I am displaying the form as a datasheet view.
I am opening the form from Form A which is building a where clause. So i'm using Docmd.Open form. User wants to have the fields displayed on Form A and then have the result form (we'll call Form B) to display with the fields selected from form A.