Form Help Please

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

I have a nice clean, useful report except for one thing. No search function.
Is there any way to put a search function on a report? If not, I have been
unsuccessful using the filter. I have a 157 page report so how can I filter
or just "jump" to the page I need? I need to find a certain school district
and then print the information on the report for that district. Each district
is on its own page in the report, so if I could just go to XYZ district
without having to scroll al the way through it would help. Thanks so much!!!!!
 
I have a nice clean, useful report except for one thing. No search function.
Is there any way to put a search function on a report? If not, I have been
unsuccessful using the filter. I have a 157 page report so how can I filter
or just "jump" to the page I need? I need to find a certain school district
and then print the information on the report for that district. Each district
is on its own page in the report, so if I could just go to XYZ district
without having to scroll al the way through it would help. Thanks so much!!!!!
Click to expand...

You're unclear on the concept of Access Reports.

The thing to do is to filter the data before the report is run, then
the Report shows only the data you want.

Create an unbound form.
Add a combo box.
Set the Row Source of the combo box to include the District field.
Name the Combo Box 'FindDistrict'.
Set it's Bound column to 1.
Set the Column Width property to 1"

Add a Command Button to the form.
Code the button's click event:

Me.Visible = False

Name this form 'ParamForm'.

Create a query that will return all of the fields needed in the
report.
On the query's [District] field criteria line write:
forms!ParamForm!FindDistrict

Next, code the report's Open event:
DoCmd.OpenForm "ParamForm", , , , , acDialog

Code the report's Close event:
DoCmd.Close acForm, "ParamForm"

When ready to run the report, open the report.
The form will open and wait for the selection of the District.
Click the command button and then report will run.
When the report closes, it will close the form.

Only records for the selected district will be shown.
 
You've posted in a "reports" newsgroup.

Your Subject: refers to "Form Help".

Can you clarify a bit more?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top