stop the user tab-ing to a new record

[Geordie2008]

Hi all,

I managed to disable the scroll button on the mouse using VBA and stop the user selecting the toggle buttons at the bottom of a form by setting "Navigation Buttons" to No.

However, I just noticed that I can tab through all of the fields in the current form record and when I reach the last field it then goes to the first field of a new record....

this is BAD....

How can I prevent?!??

Thanks,
Mand.

 

[namliam]

It is a property on the form. In the other tab, Cycle is set to "all records" by default.
Change it to "Current record" to get what you want.

 

[Geordie2008]

Phew.....

Thanks,

 

[namliam]

Sometimes its easy