Form.
You can use the Cycle property to specify what happens when you press the TAB key when the focus is in the last control on a bound form.
The Cycle property uses the following settings.
Setting | Description | Visual Basic |
All Records | (Default) Pressing the TAB key from the last control on a form moves the focus to the first field in the next record in the underlying source of data. | 0 |
Current Record | Pressing the TAB key from the last control on a form moves the focus to the first control in the tab order on the form in the same record. | 1 |
Current Page | Pressing the TAB key from the last control on a page moves the focus back to the first control in the tab order on the page. | 2 |
You can set the Cycle property in the forms property sheet, a macro, or using Visual Basic.
You can set the Cycle property in any view.
When you press the TAB key on a form the focus moves through the controls on the form according to the controls place in the tab order.
You can set the Cycle property to All Records for forms designed for data entry. This allows the user to move to a new record by pressing the TAB key.