title: How do I list Access Form control names from another database?
body: <p>I went to a Access Meetup Group recently and saw a rather cool idea demonstrated; create a code library database that holds code to return names and properties of tables, forms etc from a database then reference from the database being developed. By doing so I have a modal form that can tell me what tables I have, what fields are in them etc with all the code housed in the code library which I can then un-reference when I'm done. The problem I'm facing is how to loop through the forms collection to list the forms and their controls that exist in the calling database as I can't use CurrentDb like I can for tables. I've been searching Google, and even ventured on to the second results page, and have found Containers which might be what I am loking for but I can't make it work. I'm 99% certain that the guy giving the demo showed forms listed in his modal form. (Foolishly I didn't get his name or else I'd contact him). </p>
  
  <p>I've tried using CurrentProject.Application.Forms but Access says it can't find the form. Does it need to be open for this to work?</p>
  
  <p>Is what I'm trying to do possible? Any ideas I can try?</p>
  
  <p>PS: I cross posted this from UtterAccess.</p>