Access 2007 form TAB issue

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.

Karl,

Open your form in design view.

Display the Properties dialog box and select the "Other" tab.

On that tab you should see a "Cycle" property. Change its value from "All
records" to "Current record". This will cause the focus to move back to the
control with the smallest tab index when the user hits tab while in the last
field.

HTH
Dale


-Karl wrote:
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.

--
HTH

Dale Fye

Message posted via http://www.accessmonster.com

BTW,

The "Database Design" (or "Tables" in some groups) newsgroup is generally
more for table design questions. Your question would have been more
appriately placed in the "Forms" group.

Dale

-Karl wrote:
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.

--
HTH

Dale Fye

Message posted via http://www.accessmonster.com

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

"-Karl" wrote:

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.