I'm new to the Pass-Through Queries and I'm trying to understand the concept of them and how to incorporate a query criteria to them, or a parameter in SQL Server. I have a main form with 4 different subforms. All the subforms recordsources will be pass-through queries pulling data from my BE which is in SQL server. On the main form there is a combobox that a user can select a part number. Once that part number is selected I need the 4 subforms to requery the data and filter the results to only show records that have that part number in a specific field. The old way of doing it would just be to reference the forms combobox in the query criteria of that specific field. In learning a little about pass-through queries over the past couple of days I found out that you cannot reference a forms control in the query criteria. So I'm trying to figure out the best way to create these query criterias that are just like referencing a forms control. The pass-through queries are not all identical for starters. They all have different values since they are pulling from different tables in SQL. Secondly there are some pass-through queries that are the ground floor queries and then above them there are other queries that sum & group the data, so some of these are not the subforms direct recordsource. So I do not think I can go the route of creating these in the forms VBA and using them as the recordsource since the data still needs to be summed and grouped in other queries. Can anyone shed some light on how I can incorporate criterias that pull from the main forms combobox control? I hope I explained my situation clearly enough but if I didn't feel free to ask. I'm not asking for someone to create my solutions. I'm just looking for someone to help me walk through the best approach to adding criterias to my queries in some fashion.