Query suggestions

[jasn_78]

I have a series of seperate forms that all my main forms refer to that allow the user to choose a choice between specific departments, subdepartments and groups to filter the report by, now at the moment I am storing this data in a query that is created once the user has chosen their options. At the moment the only way I have been able to figure how to implement this into the master query for the report the user wishes to run is by creating the sql for that query in VBA rather than storing it as a prefab query in access, this as you can imagine is getting very tiresome as I have to edit all my sql after I have created the initial query to take these queries into account. My question is there a better way that someone can suggest to me?

 

[Galaxiom]

I don't really understand the question However when you open a form you can specify filters and where clauses from within the command. Normally you would use these to filter the output from the basic query in the Record Source.

 

[jasn_78]

Galxiom, basically in the database I am working with (which is a 3rd party db) I have on each product a department, subdepartment and group. I wish to be able to choose more than one of any combination of these and then use these in my report options. At the moment I have these listed in seperate drop down boxes on seperate forms due to the fact they take way too much room on the main form then store these values in a temporary query to be used as part of the main query.