Results 1 to 6 of 6
  1. #1
    wings is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2015
    Posts
    4

    Can't go to next record from one of multiple pages in tab control

    Using Access 2007: I have a form with three pages in a tab control: Data-1, Data-2 and Data-3. These pages all display information from a single record; they were only created for ease of user input. The records are stored in a SQL server with Access as the front end.

    When I am on Data-1 or Data-2, I can use the record selectors at the bottom of the form to move forward and back between records.
    I just created Data-3 today, cutting and pasting some controls from Data-1 onto Data-3.

    The record selectors don't work when I am on Data-3. I've examined the properties, and all three pages are identical except for their names and page numbers. I checked the Cycle property of the form containing the tab control, and it's set to "All Records."

    I can't figure out why cycling thorugh records can't be done from my new page, when I can do it from the others.

    Any help or advice would be appreciated.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    I don't understand "all three pages are identical" - why would they be identical? Doesn't each display different fields?

    If you want to provide db for analysis, follow instructions at bottom of my post. Import tables to the frontend copy.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    wings is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2015
    Posts
    4
    Thanks for the quick response. I guess I wasn't clear. The PROPERTIES of all three pages are identical (except for the names and page numbers). There are different fields on each page.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Not enough info to analyze the issue. I've never encountered that before. Would have to review your db.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    wings is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2015
    Posts
    4
    OK. One thing I didn't try was to compact and repair. (just thought of it). I'll try that tomorrow, and if that doesn't work, I'll see if I can get the DB small enough to send a copy.

  6. #6
    wings is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2015
    Posts
    4
    After closing Access and turning my computer off and on again, the problem went away. I already marked this solved, so I hope this comment doesn't open the thread again!

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

Similar Threads

  1. Tab Control - Tab between pages
    By manakar in forum Forms
    Replies: 3
    Last Post: 08-10-2014, 12:15 AM
  2. Tab Control Pages
    By Cleave_1b in forum Programming
    Replies: 4
    Last Post: 07-21-2014, 06:29 PM
  3. Anchor pages in tab control
    By snoopy2003 in forum Programming
    Replies: 2
    Last Post: 03-24-2012, 08:26 AM
  4. Using tab control pages
    By queenbee in forum Programming
    Replies: 1
    Last Post: 02-28-2009, 09:43 PM
  5. Tab Control Pages
    By queenbee in forum Access
    Replies: 1
    Last Post: 02-28-2009, 10:21 AM

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