Click here to Skip to main content
15,902,842 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I created a access form ,this form insert data by a button(with vba code),
but user can insert by pressing Tab ,how can I disable that by VBA?
Updated 8-Apr-12 19:03pm

1 solution

To disable "next record" (when user press tab on the last field), you need to move the cursor back to the first field.
How to do that?
In the form's properties set the Cycle property to Current Record (Other tab).
Share this answer
Nima.naqipoor 11-Apr-12 2:40am    
Maciej Los 11-Apr-12 14:40pm    
welcome ;)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900