Results 1 to 3 of 3
  1. #1
    raffi is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    Inside a Sub Procedure
    Posts
    88

    requery subform in tab Control

    Hello i have a Main Form, which has a Tab Control, and within the tab control, i have 4 pages, each page contains a subform with child fields linked to the main form with combo-box's.



    i try'd setting the combo-box after update event macro

    Code:
    reqeury
    
    subform name
    but it doesnt work, maybe its cuz its in a tab control ? how can i get passed around that ?

    Thank You

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I would use only 1 subform. Otherwise it can lead to OUT OF MEMORY errors.
    on the TAb change, swap the source

    Code:
    Private Sub tab1_Change()
    Select Case tab1.Value
        Case 1
           SubForm.SourceObject = "frmSubEmp"
        Case 2
           SubForm.SourceObject = "frmSubPHONES"
    End Select
    End Sub

  3. #3
    raffi is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    Inside a Sub Procedure
    Posts
    88
    thanks friend

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

Similar Threads

  1. Subform Requery Trouble
    By ztpkng in forum Forms
    Replies: 2
    Last Post: 06-19-2014, 04:02 PM
  2. requery subform
    By nswhit in forum Forms
    Replies: 2
    Last Post: 05-16-2013, 09:34 AM
  3. requery in subform
    By putte11 in forum Forms
    Replies: 7
    Last Post: 04-22-2013, 02:43 PM
  4. Replies: 3
    Last Post: 04-17-2012, 10:28 AM
  5. Refresh Requery Subform
    By eww in forum Programming
    Replies: 1
    Last Post: 04-05-2011, 09:19 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