Forms based on query - Need help!

[hermanko]

Hi,

I would like to know how I can set up a form (with 2 subforms) that are
based on queries, but the specific query depends on the user selection
from a combo box. My database has this structure:

Let's say i am collecting data from several different departments and i
need to separate the info for each dept into two sections on a form.
So, i have two queries/dept that extracts certain info....

Queries:
"Business Unit A - Info Part 1"
"Business Unit A - Info Part 2"
"Business Unit B - Info Part 1"
"Business Unit B - Info Part 2"
"Business Unit C - Info Part 1"
"Business Unit C - Info Part 2"

Right now, i have created a form for EACH business unit. i.e. I have a
form called "Business Unit A Info", which is based on the first 2
queries, and an action macro will open up this particular form if the
user selects Business Unit A in the dropdown list. similarily for B and
C. The problem is, this isn't efficient as the number of departments
can grow. How can i create ONE form that can be opened to display any
group of queries depending on the user selection?

Thanks in advance!
Herman

 

[SteveS]

Herman,

Since we can't see your database, would you post the SQL of "Business Unit A -
Info Part 1" and "Business Unit B - Info Part 1"? And the same for the "...Part2"?