Search results for query: *

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.

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...

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.

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...

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?

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...