Please Help... Filtering Records

[davidg]

I am using the Orders Page template as a base to build an Orders application for a company I work for. They want to be able to filter multiple fields in the Orders Sub form to determine if an equal order has been placed in the past. But, I do not know how to do a Query by Form on the Order details section of the Orders page. I have changed the form a little to meet my companies needs. I have taken the quantities out of the sum and have added a Begin Date and End Date, Name of Country, and Product Type. I need to run a filter that would tell me if a product has been sold to be used in a particular Country as the same Type, between the Begin and End dates I have specified in the Order. Can someone please help me figure out how to do this? Thanks

 

[Rob.Mills]

Let me see if I understand you correctly. You have a form with a subform in the details section of the main form that shows multiple records. And you want the user to be able to enter multiple criteria to filter the records in the subform.

I would base the subform on a parameter query and in each field that you want to be able to filter you can set the criteria to a textbox on the main form where the user enters the criteria.