Microsoft Office® Access 2007 Inside Out

Controlling Tabbing on a Multiple-Page Form

In Chapter 13, you learned how to create a multiple-page form as one way to handle displaying more data than will fit on one page of a form on your computer screen. You also learned how to control simple tabbing on the form by setting the form’s Cycle property to Current Page. One disadvantage of this approach is you can no longer use Tab or Shift+Tab to move to other pages or other records. You must use the Page Up and Page Down keys or the record selector buttons to do that. You can set Cycle to All Records to restore this capability, but some strange things happen if you don’t add code to handle page alignment.

To see what happens, open the frmXmplContactsPages form in the Conrad Systems Contacts sample ...