Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    1

    Arrow Unanswered: Hiding Form Tabs based on Criteria

    I am designing a DB that is used to submit participant information to the D.O.E. If the program participant meets a certain criteria only certain forms need to be filled out.

    Current Participant needs Academic, and Counseling tabs. does not need educational information.
    Prior Participant needs Educational information

    etc.

    Is there a way to hind a form tab based on data entered in a certain field?

    Is there any reading material that could point me in the right direction.

    ANY HELP IS GREATLY APPRECIATED!

    Thanks

    Dave

  2. #2
    Join Date
    Nov 2002
    Location
    Hillsboro, OR, USA
    Posts
    59

    Re: Hiding Form Tabs based on Criteria

    Depending on how you label your participants, something like this:
    Code:
    Select Case me.ParticipantType 
    
       Case "Current"
    
          Me.TabCtlMain.Pages("AcademicTab").Visible = True
          Me.TabCtlMain.Pages("CounselingTab").Visible = True
          Me.TabCtlMain.Pages("EducationalTab").Visible = False
    
       Case "Prior"
    
          Me.TabCtlMain.Pages("AcademicTab").Visible = False
          Me.TabCtlMain.Pages("CounselingTab").Visible = False
          Me.TabCtlMain.Pages("EducationalTab").Visible = True
    
    End Select
    Or maybe this:

    Code:
          Me.TabCtlMain.Pages("AcademicTab").Visible = me.AcademicParticipant.value
          Me.TabCtlMain.Pages("CounselingTab").Visible = me.CounselingParticipant.value
          Me.TabCtlMain.Pages("EducationalTab").Visible = me.EducationalParticipant.value
    Does that help?

Posting Permissions

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