Form parameter\2nd query questions

[lbeham]

I have a form using 3 ask parameters and a 2nd query that looks up information in another approved list query. I would like to use the information in one of the 1st three parameters to fill in that parameter information into the 2nd query. How do I do that? For example, I ask for name, start date, end date in 3 ask parameters, then in the 2nd query, I want to use the name from the 1st ask parameter to automatic pull information based upon the name without having to ask again.

 

[CEH]

Sounds like your using the "Pop up" parameter boxes.... easiest method is to create a form to hold you parameters.... for example dates.... "Start" and "End" then in the criteria of you underlying query reference that form...... insert following in the criteria for date (without quotes.. "Between [Forms]![frmReports]![txtStartDate] And [Forms]![frmReports]![txtEndDate]"
Where the form is called "frmReports" and your beginning date is "txtStartDate" so on....