Results 1 to 6 of 6
  1. #1
    Lisa C is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Jul 2012
    Posts
    3

    Change the tab behavior for the last field in the tab order

    Hello All,

    I am having a problem with a form I made with Accses 2000 and have since converted to 2010. Somehow the tab's behavior changed and not will not move me to the next record in the form. I tried what was suggested on the link below by changing
    the Cycle box to "All Records" but that does not work. Can someone please give me another suggestion?



    http://office.microsoft.com/client/h...94c182bba6#BM3

    Thank You.

  2. #2
    help_me_with_access is offline help_me_with_excel
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    262
    where does the focus move? back to the ctrl with tab = 1? if it doesn't, there are tabs that you don't know about...
    could that be it?

  3. #3
    Lisa C is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Jul 2012
    Posts
    3
    Thank you for your reply.

    It goes back to the beginning of the form, tab 0. I have 63 tabs and I don't believe there are any I don't know about.

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Click on the magical Office Button then go to Access Options – Advanced and change the 'Move After Enter' Option from the default, which is 'Next Field' to 'Next Record.'

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Lisa C is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Jul 2012
    Posts
    3
    Thank you for your reply. I made those changes but it still does not move to the next record.

  6. #6
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Based on what you've tried/reported, I'd guess that there is code somewhere, maybe in the LostFocus or OnExit events, that is causing this behavior.

    I guess you're going to have to Zip your file and attach it to a post so that we can open it and see if we can figure out what is going on. If there are multiple Tables, give us the name of the errant one.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-24-2012, 02:19 PM
  2. Columns change order
    By copaaccess in forum Queries
    Replies: 1
    Last Post: 02-28-2012, 08:52 PM
  3. Replies: 8
    Last Post: 01-30-2012, 02:13 AM
  4. Query to flag daily change in order status
    By Relyuchs in forum Queries
    Replies: 1
    Last Post: 01-21-2011, 02:53 PM
  5. Records change order
    By accessbeginner in forum Access
    Replies: 1
    Last Post: 03-18-2010, 06:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums