Subform Help!!

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • kufre
    #1

    Subform Help!!

    I'm using Access 97, I have a problem with my form. I have a subform
    inside my form. I would like to diable the subform if submission
    number is 1 and enable it if it is greater than 1. I will only use the
    subform if submission number is greater than 1. or make it a subform a
    require field if submission number is greater than one. I've try
    several code but none of them seem to be working.
    Private Sub Submission_Numb er_AfterUpdate( )
    If Me!Submission_N umber = 1 Then
    Me.tblFiling_su bform.Visible = False
    Else
    Me.tblFiling_su bform.Visible = True


    Please help, any suggestion would be greatly appreciate.

    Tags: None
    • PC Datasheet
      #2
      Re: Subform Help!!

      Also put your code in the main firm's Current event.

      --
      PC Datasheet
      Your Resource For Help With Access, Excel And Word Applications
      resource@pcdata sheet.com
      https://www.pcdatasheet.com



      "kufre" <kufreanaka@yah oo.com> wrote in message
      news:1110292029 .648202.106680@ l41g2000cwc.goo glegroups.com.. .[color=blue]
      > I'm using Access 97, I have a problem with my form. I have a subform
      > inside my form. I would like to diable the subform if submission
      > number is 1 and enable it if it is greater than 1. I will only use the
      > subform if submission number is greater than 1. or make it a subform a
      > require field if submission number is greater than one. I've try
      > several code but none of them seem to be working.
      > Private Sub Submission_Numb er_AfterUpdate( )
      > If Me!Submission_N umber = 1 Then
      > Me.tblFiling_su bform.Visible = False
      > Else
      > Me.tblFiling_su bform.Visible = True
      >
      >
      > Please help, any suggestion would be greatly appreciate.
      >[/color]


        Comment

        • kufre
          #3
          Re: Subform Help!!

          I try putting this code into the form's current event but I keep
          getting a error message "Microsoft Access Can't find the field
          'Submission_Num ber referred to in your expression". I'm not sure what
          that mean. I'm also not sure why I should put the code in the main
          form's current event. Please explain.

          Thank you in advance.

            Comment

            Previous template Next
            Working...