Search All Subforms-CrossPost

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

    Search All Subforms-CrossPost

    Please Help!

    I have read over and over again to go to Allen Browne's website to
    filter subforms, but I just don't understand it, and I can't get it to
    work in my situation. Any advice is very appreciated.

    I have 2 forms. Mainform=Custom ers Subform(linked) =Service
    Requests.

    The two forms have a one to many relationship (many service requests
    per customer) and are related by customer number (auto number that
    automatically is filled in subform to match field on mainform). Each
    service request has a txtBox for TicketID. I want to be able to
    search through all of the TicketIDs in all of the customer's service
    requests (TicketID is not an auto number and can't be used as primary
    key-it is a number typed from a tablet of paper with a number at the
    top-there could be multiple instances of this number if he orders a
    new tablet of paper and it starts with the same number-very very small
    company). I have created another subform (which may not be needed,
    but I thought it might help) that just displays the TicketIDs (all
    TicketIDs related to the customer number) from the service request
    table on the mainform.

    The search button that the wizard creates will not even search the
    TicketIDs on the current customer ID's page, none the less searching
    through all customer's pages to find the corresponding Ticket IDs. And
    when I put the search button in the subform, it will only search for
    TicketIDs related to the current customer number (which I like)

    Is what I am trying to do possible? I am VERY new to Access (about 2
    weeks into it) and just want to make this database for my family's
    Clock Shop. Thank you for any help you can provide!

    Tags: None
    • Allen Browne
      #2
      Re: Search All Subforms-CrossPost

      See:
      Filter a Form on a Field in a Subform
      at:
      Microsoft Access tips: Filter a Form on a Field in a Subform
      http://allenbrowne.com/ser-28.html
      How to filter a form in a Microsoft Access database, based on a field that is not in the table the field is bound to.


      --
      Allen Browne - Microsoft MVP. Perth, Western Australia
      Tips for Access users - http://allenbrowne.com/tips.html
      Reply to group, rather than allenbrowne at mvps dot org.

      "Robert Jacobs" <robertjacobsit @gmail.comwrote in message
      news:1175867010 .772313.164210@ b75g2000hsg.goo glegroups.com.. .
      Please Help!
      >
      I have read over and over again to go to Allen Browne's website to
      filter subforms, but I just don't understand it, and I can't get it to
      work in my situation. Any advice is very appreciated.
      >
      I have 2 forms. Mainform=Custom ers Subform(linked) =Service
      Requests.
      >
      The two forms have a one to many relationship (many service requests
      per customer) and are related by customer number (auto number that
      automatically is filled in subform to match field on mainform). Each
      service request has a txtBox for TicketID. I want to be able to
      search through all of the TicketIDs in all of the customer's service
      requests (TicketID is not an auto number and can't be used as primary
      key-it is a number typed from a tablet of paper with a number at the
      top-there could be multiple instances of this number if he orders a
      new tablet of paper and it starts with the same number-very very small
      company). I have created another subform (which may not be needed,
      but I thought it might help) that just displays the TicketIDs (all
      TicketIDs related to the customer number) from the service request
      table on the mainform.
      >
      The search button that the wizard creates will not even search the
      TicketIDs on the current customer ID's page, none the less searching
      through all customer's pages to find the corresponding Ticket IDs. And
      when I put the search button in the subform, it will only search for
      TicketIDs related to the current customer number (which I like)
      >
      Is what I am trying to do possible? I am VERY new to Access (about 2
      weeks into it) and just want to make this database for my family's
      Clock Shop. Thank you for any help you can provide!
      >

        Comment

        • Robert Jacobs
          #3
          Re: Search All Subforms-CrossPost

          On Apr 6, 9:28 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
          See:
          Filter a Form on a Field in a Subform
          at:
          Microsoft Access tips: Filter a Form on a Field in a Subform
          http://allenbrowne.com/ser-28.html
          How to filter a form in a Microsoft Access database, based on a field that is not in the table the field is bound to.

          >
          --
          Allen Browne - Microsoft MVP. Perth, Western Australia
          Tips for Access users -http://allenbrowne.com/tips.html
          Reply to group, rather than allenbrowne at mvps dot org.
          >
          "Robert Jacobs" <robertjacob... @gmail.comwrote in message
          >
          news:1175867010 .772313.164210@ b75g2000hsg.goo glegroups.com.. .
          >
          >
          >
          Please Help!
          >
          I have read over and over again to go to Allen Browne's website to
          filter subforms, but I just don't understand it, and I can't get it to
          work in my situation. Any advice is very appreciated.
          >
          I have 2 forms. Mainform=Custom ers Subform(linked) =Service
          Requests.
          >
          The two forms have a one to many relationship (many service requests
          per customer) and are related by customer number (auto number that
          automatically is filled in subform to match field on mainform). Each
          service request has a txtBox for TicketID. I want to be able to
          search through all of the TicketIDs in all of the customer's service
          requests (TicketID is not an auto number and can't be used as primary
          key-it is a number typed from a tablet of paper with a number at the
          top-there could be multiple instances of this number if he orders a
          new tablet of paper and it starts with the same number-very very small
          company). I have created another subform (which may not be needed,
          but I thought it might help) that just displays the TicketIDs (all
          TicketIDs related to the customer number) from the service request
          table on the mainform.
          >
          The search button that the wizard creates will not even search the
          TicketIDs on the current customer ID's page, none the less searching
          through all customer's pages to find the corresponding Ticket IDs. And
          when I put the search button in the subform, it will only search for
          TicketIDs related to the current customer number (which I like)
          >
          Is what I am trying to do possible? I am VERY new to Access (about 2
          weeks into it) and just want to make this database for my family's
          Clock Shop. Thank you for any help you can provide!- Hide quoted text -
          >
          - Show quoted text -
          Continuing conversation at:
          http://groups.google.com/group/microsoft.public.access.forms/browse_thread/thread/2cb8160975fb7783/dec2a882649f342e#dec2a882649f342e


            Comment

            Previous template Next
            Working...