Forms based on query - Need help!

  • Thread starter Thread starter hermanko
  • Start date Start date
H

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
 
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"?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Queries on Forms for User Input 1
List box subform question 1
Iff Query/Form 3
Using Between criteria to search query 1
combo box base on another, save value to a table 2
Change drop down list in one cell based on values in other cells 2
limiting options when creating a list 1
How to get query to return total using wildcard 1

Back
Top