Results 1 to 4 of 4
  1. #1
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,195

    Setting Focus On Tab Control Page


    Hi Guy's where am I going Wrong here ?

    I am trying to setfocus to a tab control page name from another form procedure

    The i want to set focus on is WEEKS_DELIVERIES (the under score i believe is to compensate for a space the page name is WEEKS DELIVERIES

    It is coming up can't find the field tbcMainMenu ?

    Code:
    Forms!frmMainMenu!tbcMainMenu!WEEKS_DELIVERIES.SetFocus

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    see this link for how to reference controls on another form

    http://access.mvps.org/access/forms/frm0031.htm

  3. #3
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,195
    Hi Guy's, thank you No wonder I can't get things working correctly, it would really help if I checked the name of the Tab Control !!!!!!,

    I had it as tbcMainMenu, it's called tbcMain Durrrrrrrr never work

    Simple as setting the focus to the index number of the tab control

    Forms!frmMainMenu.tbcMain = 3

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,943
    You can use the builder to get correct syntax as well.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Setting focus to an ID in a LISTBOX
    By sarcher in forum Programming
    Replies: 1
    Last Post: 05-05-2020, 11:48 AM
  2. Replies: 7
    Last Post: 03-09-2018, 11:11 PM
  3. Replies: 15
    Last Post: 05-12-2016, 02:27 PM
  4. Setting the focus on a control in a subform
    By fritesmodern in forum Programming
    Replies: 1
    Last Post: 07-31-2015, 09:10 AM
  5. Replies: 6
    Last Post: 09-17-2014, 01:04 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