Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tgilbride

  1. tgilbride

    Filter Form Question

    I am trying to filter the main form, so the subforms do not come into play. If I base the main form on a query, then a part number will appear for every PO that it is on. I am trying to avoid that. I am trying to only show the part number 1 time.
  2. tgilbride

    Filter Form Question

    I have a form with multiple tabbed subforms. The form is based on a table "tblPartNumber". I want it based on that, because I only want to see each part number 1 time as I scroll through the form. I have another table called tblPOPN. This table references Purchase Orders and all part numbers...
  3. tgilbride

    Filter Form Question

    Thanks for the help. Let me process this for a little bit and see if I can make this work. I will let you know.
  4. tgilbride

    Filter Form Question

    How do I link this global feature to another query that is not open? That is the real issue. In the AfterUpdate area, I want to be able to see all parts on the form that share the same PO number. However, the PO number is not an open table query. This is a bit confusing, am I explaining it...
  5. tgilbride

    Filter Form Question

    I have, but then I have to go to several different forms within my database when working with it. I was hoping to avoid that. Does this mean there is not way to do this?
  6. tgilbride

    Filter Form Question

    I have a form that is based a table ("tblPartNumber"). I have another tlble ("tblPOPN") that I would like to use in a filter, if at all possible. Bascially, tblPartnumber is made of of part number data (pricing, descrition, etc.) tblPOPN is a table that links a Purchase order to a Part...
See more

Part and Inventory Search

Back
Top