Access 2007 form TAB issue

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.
 
K

-Karl

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!
 
C

Clifford Bass

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top