Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Tabbing between pages in a form in Access 2007


(!)

krs1716's Avatar
krs1716 krs1716 is offline
Member with 438 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
09-Mar-2012, 08:23 AM #1
Tabbing between pages in a form in Access 2007
I am in the process of creating a database for work. The database will be used my people who have used access before, but they have never used a form in a database (everthing operated off of several tables).

Currently, I am using a form to input the data into the tables. My form has five pages that include various subforms. However, in order to tab from one subform to the next or one page to the next, I have to use the Ctrl + Tab function. I would prefer, for the sake of the users, to be able to just use the Tab button to move from subform to subform and page to page. Is there a way to program that into the database?
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
09-Mar-2012, 08:55 AM #2
As far as I know there is no "On Tab" event, so you can't use VBA to that.
krs1716's Avatar
krs1716 krs1716 is offline
Member with 438 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
14-Mar-2012, 12:36 PM #3
Is there a reason why the information would be erased from sight when the tab is pressed after the last field on a page? This is happening in my database. The good news...if I close the form and re-open it, the information is still there.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,649 posts.
 
Join Date: Mar 2005
Location: UK
14-Mar-2012, 01:44 PM #4
It sounds like you are "Tabbing" to somewhere that has no data.
Have you looked at the Form's "Cycle" property, you can prevent it moving from the current record by setting it to Current Record.
krs1716's Avatar
krs1716 krs1716 is offline
Member with 438 posts.
THREAD STARTER
 
Join Date: Feb 2012
Experience: Intermediate
14-Mar-2012, 01:53 PM #5
The cycle property is set to Current Record. It's only when I tab after the last field on a particular page in the form.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑