How to run multiply queries based on criteria provided by two seperate forms

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JZNYC
    New Member
    • Mar 2010
    • 1

    How to run multiply queries based on criteria provided by two seperate forms

    Hi, I am trying to fix some problems in an existing Access database.

    There is this report which has a few subreports embeded in it, which pull data from corresponding queries. The criteria for the queires come from unbound text boxes located on two seperate forms. Both forms are open while report is processed. The subreports which rely on the form where process report command is located run fine, but there seems to have no data passed from the other form.

    What do you think the solution would be. Do I need to link the two forms, and how? Or do I need to manually trigger the action of passing the form data and how?

    Thanks a lot!
Working...