Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Location
    Raleigh, NC
    Posts
    146

    Exclamation Unanswered: Question about Tabs

    I have a form with a tab control. One of the tabs displays account information (contained in Table: Accounts) and another tab contains advertising information (contained in Table: Ads). Since the tab control seems to have to have just one record source, how can I display the proper information in each tab if said information comes from more than 1 table? I'm assuming I will have to use subforms? Correct if I'm wrong or totally off track. TIA.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Try something like that:
    PHP Code:
      Private Sub Tab_main_Change()
        
    Select Case Tab_main.Value
          
    Case 0                              ' Your First Table Recordset
            Me.RecordSource = "SELECT * FROM Accounts"
          
          Case 1                              ' 
    Your second Table Recordset        
            Me
    .RecordSource "SELECT * FROM Ads"
        
    End Select 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •