Access 2007 form TAB issue

  • Thread starter Thread starter -Karl
  • Start date Start date
K

-Karl

I created a form based off a table and when I hit TAB after the last
text box, it's automatically recording my work and starting over
again. Now I have a button that I want to control what happens after
I fill in the form. I do not want to use the TAB key to start over a
new record since it's mandatory that I perform validation checks and
open a subform!

So how do i stop the TAB key from recording my work after the last
textbox? I don't see any option that is different than the other
textboxes.

Thanks!

P.S. I was able to find out how to hide the bottom navigation bar
(Where it says record 1 of X ) and so it's hidden to prevent the user
from creating blank records.
 
Sorry for the wrong forum post. I am a member of that group but I
guess I wasn't paying attention. many thanks for teh help. I was
driving myself nuts!
 
Hi Karl,

And what happens when the user presses PageUp or PageDown? It is
better to place your validation in the form's Before Insert and/or Before
Update events, as appropriate.

Clifford Bass
 
Back
Top