Dynamic Forms

[jauner]

Is there a way to to create a bunch of textboxes on a form when it is loaded based on the number of elements in an array?

For example, I have a question table that based on a certain code I am filling an array with and I would like to put these questions in order on a form. Is there any way to do this at run time? I know it can be done at design time.

[chocobochick]

In my experience, no, at least not by any normal means in Access. For whatever reason, Access doesn't seem to support an Add method for the Controls Collection on a form -- which otherwise works wonders for adding controls at run-time for Excel, Word, or Outlook UserForms (also unsupported by Access). Whenever I've wanted to create run-time controls in Access, I've usually been forced to rethink my implementation.

If you do find a way to do it, let me know. :mkay