I have an MS Access main Dashboard form that contains a number of subforms. The tables and records live in an online database and I use ODBC to connect to the tables. Rather than all subforms being displayed when the dashboard loads I'd prefer them to be opened on demand from the dashboard - this would speed up loading of the dashboard form. The subforms have some complex queries behind them. Is there any way of leaving the subforms dormant when the dashboard form first opens (so it opens nice and quick) and then opening the subforms on demand using a button click, i.e. only pull down the data for the subforms via ODBC when needed.
you can create a subform object, then set it programatically using Me.Child0.SourceObject = "MySubForm"