i have a tab and has few pages on this tab control (say 8 pages) and each page has 2 or 3 listbox displaying some info related to that job (sales, admin, warehouse etc).

when a staff login, only the page related to their job is showing (tab page visible = false) and wondering if those listbox's row source still active (but not showing due to visible put to false)?

just wondering if affects performance due to many listbox in a form, visible or not?

thanks for reading.

CodePudding user response：

Controls that are on an active, loaded form (even if they, or even the entire form, are/is not visible) can be queried against, period. Doesn't matter if they are on another tab or not. So yes, they will affect performance (likely negligibly, unless you've got thousands of or extremely complicated look-ups going on).

CodePudding user response：

If the parent container(i.e a page on the tab is not visible), then all controls on the page will not be visible.

A control not visible in this instance because the parent container is not, e.g listbox, combo box, textbox, etc, does not consume memory space.