Loop through controls on a form in a different database
Posted on 2009-07-02
I'm creating a table for all the form controls in a different database.
I open the other database using vba and DAO, Set db = OpenDatabase([Database Name]). No problem.
Using containers I can get the names of the forms in the database, again no problem.
For i = 0 To db.Containers("Forms").Documents.Count - 1
I cannot figure out how to get the controls on the form names that I have.
Set frm as db.Containers("Forms").Documents(i). Type mismatch.
In the database which has the table I am creating with form controls name, how do I loop through the form controls in a different database in order to get the controls name, or whatever I want from the form controls.
PS PLEASE do not ask why I want this. How can it be done within the VBA code for a different database?