Click here to Skip to main content
15,885,032 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?
Posted
Updated 8-Apr-12 19:03pm
v2

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
 
v2
Comments
Nima.naqipoor 11-Apr-12 2:40am    
Tanx
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