Disable TAB record navigation?

[Stevo3737]

I have a form which is populated with a record chosen by a combo box. I have set Navigation Buttons to "NO". However, when I TAB through the form and I get past my last button, I am taken to the next record.

Anyway I can stop this? The only way I want someone to be able to switch records is by selecting another value from the combo box.

 

[SOS]

Go into the form in design view and change the CYCLE property to CURRENT RECORD.

 

[Stevo3737]

Thanks! That was easy.

 

[SOS]

Thanks! That was easy.

No problem, glad we could help.

 

[Rx_]

While quickly updating someone else's code, the cycle property worked just perfectlly on a single form when the list box changes focus to a bound text box (and was forcing a new record).

Thought that there might be other answers for this solution and wondered which one best works for a situation.

Another solution posted to prevent the tab forcing the next record was:
Me.AllowAdditions = True/False

Could someone offer some general observations on when to use the Cycle property shown above vs the Me.AllowAdditions ?