form to enter parameter values delays display report and subrepor

[bpolite]

I have a main report which is linked to 5 subreports by a field call "Job
Number". Since there are many different job numbers for the reports, I have
designed a query and created an unbound form with the necessary control to
enter the parameter value. The form's parameter value is entered into the
query for the main report and all the subreports have seperate queries. The
form has an OK button that runs the query then closes the form and a Cancel
button that closes the form without running the query. The issue I'm having
is that when I enter the job number into the form I have to click the OK
button 6 times (once for the main report and the 5 subreports) before the
reports are displayed. Is there a way to display the main report and
subreports by one click of the OK button? Any help would be greatly
appreciated.

 

[Golfinray]

IIF([your field] = "part you don't want", "part you do want", [your field])

 

[Dale Fye]

It sounds like your subreports are also using parameter queries. I would
remove the parameters from them, so that when you view each of the subreports
(outside of the main report) they return all of the records.

Then, you need to open the main report in design mode, click on each of the
subreports, and set the Master and Child fields on the Properties dialog
boxes data tab to [job number]. This way, when the main report is opened to
a specific record, all of the subreports will also only reflect the data for
the parent record.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.