<div>
Should i leave the subform area blank and once they select a customer in the main form, then load the subforms????
</div>


Should i leave the subform area blank and once they select a customer in the main form, then load the subforms????

<div>
Perhaps a look at your Relationship diagram??
</div>


Perhaps a look at your Relationship diagram??

<div>
So i should have all the subform area blanks, and on the main form include in the ON CURRENT event to load the subforms, plus in the tabswhen they click on the page then load the subforms<br />
Is this correct?<br />

</div>


So i should have all the subform area blanks, and on the main form include in the ON CURRENT event to load the subforms, plus in the tabswhen they click on the page then load the subforms
Is this correct?


<div>
<div class="content wysiwyg-content">
Hi Guys<br />
I have a Main Form with a tab control where in the 1st page(tad) named Status i am showing multiple subforms from multiple queries.<br />
The purpose of this tab is show a curtrent status of the customer, i have 5 subforms in this tab, is there a way or tips that i should use to make it load faster, what should i do to avoid slowdown in my system, should i populate the information only when click in the tab, please give a hand with this, this is a very important form but i do not want to slow down my sytem<br />
any hints of proper technical details that i should use to minimize the risk of slowing down the db<br />
<br />
best regards<br />

</div>
</div>


Hi Guys
I have a Main Form with a tab control where in the 1st page(tad) named Status i am showing multiple subforms from multiple queries.
The purpose of this tab is show a curtrent status of the customer, i have 5 subforms in this tab, is there a way or tips that i should use to make it load faster, what should i do to avoid slowdown in my system, should i populate the information only when click in the tab, please give a hand with this, this is a very important form but i do not want to slow down my sytem
any hints of proper technical details that i should use to minimize the risk of slowing down the db

best regards


Form with multiple subforms

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.