In Access the Enter Key can be programmed to either go to the next record or go to the next field depending on:

The setting which can be changed using Tools, Options, Keyboard Tab, and selecting either: Move After enter - 1. Next Field or 2. Next record.

I have a form that has two sets of records. On one of the recordsets it is more convenient for the user to have the setting set on 1. Next field option. On the second set of records, it is more convenient for the user to have the setting set on 2. Next record option.

Programatically, how can I instruct Access to change from the Next Field Option to the Next Record Option without having to open the Tool > Options > Keyboard Tab and manually changing the setting?