Results 1 to 11 of 11
  1. #1
    krigsby is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2017
    Posts
    17

    Pages on Form


    I have set my form up to have several pages. However, when I move from page to page, it doesn't always begin at the top. I have tried maximize page on click and it doesn't seem to work for pages. What do I enter to have it go to the first tab on the page as you select the page and where do I attach it?

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Are you talking about the tab order?

  3. #3
    krigsby is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2017
    Posts
    17
    It looks like this
    Click image for larger version. 

Name:	Page Jpeg.jpg 
Views:	12 
Size:	25.6 KB 
ID:	28053

  4. #4
    krigsby is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2017
    Posts
    17
    When select the next page (say abuser info) it sometimes is at the bottom of the page. I want it to be at the top on the first tab stop for that page each time you click the page.

  5. #5
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    "IT is sometimes at the bottom" - what is IT? Do you mean the cursor? If so, that is called Tab Order.

  6. #6
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    You can use the tabcontrol on_change event to move the focus wherever you want...

  7. #7
    krigsby is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2017
    Posts
    17
    I am using 2010. I don't see tabcontrol in the Macro's. Can you give me the expression to use?

  8. #8
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Go to Design>Tab Order - set the order any way you want.

  9. #9
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    I am using 2010. I don't see tabcontrol in the Macro's. Can you give me the expression to use?
    I don't use macros. I did take a look, but i don't think macros offer the level of control that I suggested.

  10. #10
    krigsby is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2017
    Posts
    17
    I have the tab order set up correctly. It just doesn't begin at the correct tab order when editing a page. It just goes to the last tab you were working on when you page through. I want it to go to the first tab in each page each time you click on the page.

  11. #11
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    If you want to get into VBA, this should work. Change tabctl3 to the name of your tabcontrol and the setfocus to the desired control on the specified page.

    Code:
    Private Sub tabctl3_Change()
        Select Case tabctl3.Value
            Case 0        'first page
                 txtBox1.setfocus
            Case 1        'second page
                 cboCopany.setfocus
            Case 2        'third page
                cmdNext.setfocus
            Case Else
                msgbox "Unknown page",vbokonly,"   E R R O R   "
        End Select
    End Sub
    Last edited by davegri; 03-30-2017 at 02:53 PM. Reason: indent

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

Similar Threads

  1. Form with tabs has pages superimposed
    By pwelch in forum Forms
    Replies: 9
    Last Post: 03-30-2017, 08:22 AM
  2. Replies: 3
    Last Post: 11-10-2016, 01:06 PM
  3. Replies: 3
    Last Post: 03-21-2016, 06:28 AM
  4. Replies: 5
    Last Post: 03-05-2015, 03:46 PM
  5. Blank pages between report pages
    By jonsuns7 in forum Reports
    Replies: 2
    Last Post: 10-01-2009, 05:06 AM

Tags for this Thread

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