Printing specific records from a Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MB - 12 Jan 2006 21:06 GMT

I have three reports that have the same record source (a query called
EmpandCourse). The three reports are:

Detail by Employee
Detail by Division
Courses

When a user chooses “Detail by Employee” I would like a dialog box to ask
the user to fill in the employee name. Then, the report will only show
records for that employee.

I would also like the same for “Detail by Division” whereby the user is
prompted to fill in the Division same, and the report will then show only
records for that Division.

How do I accomplish this? Do I need to build a separate query for each
report? By the way, these report choices are on a switchboard.

Thank you so much for your help!

Signature

Reply to this Message

Pat Hartman(MVP) - 13 Jan 2006 01:36 GMT

If you are currently opening the reports from the standard switchboard built
by the wizard, you'll need to create a form instead. Add the parameter
field to the form. Add a button to the form to open the report. After the
wizard builds the code behind the button, open it in design view so you can
modify it. You will need to add a where argument to the OpenReport method.
This will cause the report to show only the specified record.
You can see syntax in help or just rely on intellisense as you modify the
code.

>I have three reports that have the same record source (a query called
> EmpandCourse). The three reports are:
[quoted text clipped - 15 lines]
>
> Thank you so much for your help!

Reply to this Message