>Greetings all.
>
>I have a question about gathering names in developer mode. I made a builder that creates arrays and SQL statements for validation or lookups. The SQL statement will be built with any number of where clauses based on user’s input. To simply the SQL statement, the builder creates MVs that contain the ‘where’ logic and this mv is then evaluated in the SQL statement with the & operator.
>
>After the base code is created, the developer then must fill in the control names for the ‘where’ logic. In most cases the code is used for finding records. So the controls will have the desired data qualifications you will search by.
>
>In design mode, can I gather the control names from a particular form in order to select them from a dropdown list to further complete this builder?
You can drill down through controls on a form and collect whatever information you want. This article contains code that does it:
https://tomorrowssolutionsllc-public.sharepoint.com/Articles/Fix%20Control%20Names%20Easily.PDFLook at the section titled "Building a list of controls."
Tamar