Here's a simple tip to avoid problems associated with referencing the individual pages (tabs) of a Microsoft Access tab control in VBA.

Tabs are powerful and easy to use on Microsoft Access forms. A tab control contains pages (tabs) with each page identified by its PageIndex property starting with 0. The value determines the order of the tabs. However, if you reference the pages by number, your code may fail if the pages are reordered, new ones added or pages deleted. 

See how you can avoid this problem and read about other tips for creating better and faster Access forms.