MultiQuery Form

[DennisORA]

How do I set up a multi-query MS Access form? Both queries ask the users for input parameters. Actually, both queries use the same tables, but different joins. I'm trying to list a manager line, with detail lines below for each employee managed.

 

[traingamer]

Have you tried subforms?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[DennisORA]

No, I haven't tried subforms. Do you mean displaying manager info in the form and employees on the subform?

 

[MajP]

Not sure of the data you are displaying. It could be as you described, or you could have two or more subforms on a mainform that are not linked to the main or to each other. Two different views of the same data, sorted differently, with different fields.