Capturing Parameter from Parameter Query

[MTrem]

I have a form whose data source is a select query, q3, that is built from 2 other select queries. I'll call them q1, q2, and q3. q1 is a parameter query where I enter a "Cutoff Date" that the 3 queries manipulte and generate the desired results that appear in the form. The problem is that I don't know how to capture the parameter "Cutoff Date" from q1 to display on the form.

 

[andrew93]

Rather than just using something like [Enter Cutoff Date] as the criteria in q1, create a new field in your query called "CO_Date : [Enter Cutoff Date]" (without the quotes). Make sure you have the identical wording in this new column and under the field that you are using this criteria (just the "[Enter Cutoff Date]" part, without the quotes). You will now have a column in your q1 titled 'CO_Date' that you can pass through to q3 and then on to your form.
HTH, Andrew

 

[neileg]

Or create a text box on your form for the user input and makethe query criterion point at this text box.