Results 1 to 2 of 2
  1. #1
    queenbee is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2009
    Location
    Ohio
    Posts
    3

    Question Using tab control pages

    I am using the following code that works!

    Private Sub NoticeID_Click()
    On Error GoTo Err_Notice_Click
    Dim FormName As String
    Dim LinkCriteria As String

    FormName = "NoticeDetail"

    LinkCriteria = "[NoticeID] =""" & Me.NoticeID & """"

    DoCmd.OpenForm FormName, , , LinkCriteria
    Exit_Notice_Click:
    Exit Sub
    Err_Notice_Click:


    MsgBox Err.Description
    Resume Exit_Notice_Click
    End Sub

    I am experiencing a problem when I change FormName to a TestForm with tab control pages, the data is not filtering into the TestForm. Any suggestion on how to make it work?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I thought I answered this in one of the forums. The Tab Control should not make any difference. The WhereCondition argument of the OpenForm command simply puts a filter on the MainForm. If you have SubForms on your tab control, they are not directly addressed except through the LinkChild/MasterFields properties of the SubFormControls.

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

Similar Threads

  1. Tab Control Pages
    By queenbee in forum Access
    Replies: 1
    Last Post: 02-28-2009, 10:21 AM
  2. Control navigation pane
    By ohporter in forum Access
    Replies: 0
    Last Post: 05-27-2008, 12:45 PM
  3. Sending control to specific control
    By wasim_sono in forum Programming
    Replies: 2
    Last Post: 04-19-2007, 08:19 AM
  4. No object in this control
    By mtrcar1 in forum Access
    Replies: 0
    Last Post: 10-12-2006, 05:31 PM
  5. Grid Control - or something like that.
    By rhunt in forum Programming
    Replies: 1
    Last Post: 12-15-2005, 04:46 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