If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Access 2007 form TAB issue
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 |
#3
|
|||
|
|||
Access 2007 form TAB issue
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 |
#4
|
|||
|
|||
Access 2007 form TAB issue
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! |
#5
|
|||
|
|||
Access 2007 form TAB issue
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. |
Thread Tools | |
Display Modes | |
|
|